Figuring out the run time of scheduled jobs

[Julian Hoch]

I've been trying to figure out how long certain jobs run by evaluating the sys_trigger table.

The jobs I'm investigating are not in the definition table (sysauto) but are generated by some script. I can see when the job is created, but not when it finishes since it's automatically getting deleted.

Does anybody know a way to calculate the run time duration of the scheduled job after the fact?

[Ankur Bawiskar]

Hi Julian,

May be active transactions shows the background scripts which execute in system. you can have a look on that.

Mark Correct if this solves your issue and also hit Like and Helpful if you find my response worthy based on the impact.

Thanks

Ankur

[ankit_sharma487 · Accepted solution]

I am not sure if i am answering write but i could see only via syslog_transaction. i had a job and when i run that or gets run on schedule it comes under transaction log. may be t_anurag, will have some insight .

Thanks Anurag in advance .

[Julian Hoch]

Yes, the "Transactions (Background)" module shows the time (and even some more interesting stats) about the completed jos. Thanks!

[Kumar38]

Hi Julian ,

I have a  similar requirement , How do I filter down the search results (using URL , Type) field to find my Scheduled Job in Transaction Log (syslog_transaction) table . when I do URL Contains it returns me more than 1 record . My scheduled Job is a Script and What fields do I need to report on Job's Performance?