Capture job and script Execution Times

[Nicolas6]

Hello Everyone.

My client is trying to measure not only the average and highest execution times for jobs and scripts, but also be able to know which job or scripts are exactly taking so much time to run. I tried to find a dashboard OOO or something that can help me with this, but I only found a really simple homepage called "serviceNow Performance", that provides an overall of response times but without any detail of what is triggering those high response times.


Do you know if something like this exists? And if it does not, is there any table I can use to get this information and create indicators by my own?

Thank you in advance!

[Maik Skoddow · Accepted solution]

Hi

go to table "syslog_transaction" and filter for Type "Scheduler". In column "URL" you find the name of the Job. 

And then check all the available columns. They contain tons of information.

Kind regards
Maik

[Nicolas6]

Thank you, That may work.
Do you know if something similar exists for scripts?

[Maik Skoddow]

Hi

no, because it makes no sense, as scripts are always embedded in any kind of context. Like the above mentioned jobs. They execute some scripts, but at the end only the execution of the job as a whole counts and not the involved scripts.

Kind regards
Maik

[Maik Skoddow]

Hi @Nicolas 

In case you think I was able to answer your question, I would be happy if you mark the appropriate response as "correct" so that the question will appear as resolved for other users who may have a similar question in the future.

If not, please tell me what you are still missing!

Many thanks & kind regards
Maik