Log to get total time to execute transform map

[Hafsa1]

I have a scheduled job which runs a transform map consisting of 2-3 transform scripts. This is to import(insert+update) data in CMDB_CI table. Now I have to find out the total time to run the scheduled job+transform import+transform load+transform script run time. Means total time from beginning to end to complete the job and update+insert+ignored time .

Which all logs i need to check?

[Joshwa Antony S]

Hello,

Check transform history and import run history “Run time” field.

Doc: https://docs.servicenow.com/bundle/orlando-platform-administration/page/administer/import-sets/reference/r_ImportRunHistory.html

Regards,

JAS

[scott barnard1 · Accepted solution]

Hi Hafsa

First place is the Transaction Log

I would use the query  - sys_created_onONToday@javascript:gs.daysAgoStart(0)@javascript:gs.daysAgoEnd(0)^urlSTARTSWITHJOB

This gives you the job lists - and will give you the breakdown of the times on the job.

Modifying the columns will show you Response time, wait time,SQL count time etc

Note your JOB will be JOB: Name of your Job

You can then look at Transform History.

Transform history tells you the detail within the map itself including Run time, inserts, updates etc.

Note that a scheduled job does not run exactly when you schedule it. It becomes available to run then but other activity on the platform can push it back and it may run later than expected.

Regards