7
Views
4
Comments
Query Oslog_cyclic_job from cloud environment
Application Type
Traditional Web
Platform Version
11.10.0 (Build 22422)

Hi,

Is it possible to query oslog_cyclic_job using the cloud environment ? 

I would like to get the timestamp from the last time a job ran with success. 


select convert(varchar(19),max(instant),120) from oslog_cyclic_job

where cyclic_job_key = 'cyclic_job_key'

and error_id=''


Thank you.

Rank: #170

Hi Pedro,

See the image, how to get this table:

or

Regards.

You have the entities in the System module, so, you can use a simple aggregate to get the information. 

Regards 

Graça

Rank: #49948

Thank you very much !