[SOLVED] If there is a way to retrieve the caster job start/end time through code.

Focal Point

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/7407046096

July 31, 2018, 04:03 AM

Veeramani Karuthapandian

[SOLVED] If there is a way to retrieve the caster job start/end time through code.

Dear Team,

If there is any way to retrieve the report caster job start/end time through webfocus code.

Scenario:
Report Caster - WebFOCUS 7.7.03 version.
Example: daily reports job, we scheduled 5 jobs in report caster.

Each report caster job log, we could see start/end time as manually. but we need to retrive the informations through web focus table code.

please help us to complete the task.

Thanks,
veeramani K

This message has been edited. Last edited by: FP Mod Chuck,

July 31, 2018, 08:09 AM

MartinY

You can create a master file for BOTLOG table which exist under an SQL DB (if your RC repository is configured on a SQL server) and then have the START_STAMP and END_STAMP.
But you will have to convert them to a real date/time field since they are a number of seconds since 1900-01-01 if I'm not mistaken.

July 31, 2018, 12:24 PM

Balakrishnan Palanisamy

More detailed explanation of this available in
http://forums.informationbuild...1057331/m/9267020476 link