Slow Job Log: What are these jobs?

[hanaphouse]

I was trying to troubleshoot the list in the Slow Job Log. Is anyone familiar with these OOB jobs? If yes, can you help explain what each does?

• JOB: [AppSec] Daily Data Management
• JOB: Calculate Depreciation
• JOB: Collect Table Stats
• JOB: System Trigger2020-05-28 09:00:43
• JOB: TS Index Stats

[Jaspal Singh]

Hi,

Each of above will have an entry in sys_trigger (Scheduled Job) table i.e. from Application Navigator

System Scheduler >> Scheduled Jobs>> Scheduled Jobs.

You can search with name & get the record. You need to open & then look for the script field which will have possible script include & function being called.

For eg. Calculate Deprecation has below.

These are system specific OOB scheduled job that are in place for some or other action in backend & may/may not execute everyday.

Look for each one you highlighted & get an understanding of what is that job meant for.

[hanaphouse]

I have checked the slowest job: [AppSec] Daily Data Management. However, it only shows job_context which I don't have any idea on what it is for in Service-Now.

The scheduled job does not run any script or query to the server, but why is it the slowest job?

[Jaspal Singh · Accepted solution]

You see the fcDocumentKey that is the sys_id of a record from sys_trigger (Scheduled jobs) table.

So, copy the sys_id from application navigator look for System Definition >> Scheduled Job & then search by sys_id you will get the related record.

[hanaphouse]

That's awesome. I found the script and the actual scheduled job configuration. I wished SNow named fcDocumentKey to something like sys_id so I would have a clue on what it is for. 🙂

var obj = new SecurityDashboardHardeningFunctions();
obj.initAllFunctions();

// get PA job and execute it.
var appsec_pa_job = new GlideRecord('sysauto_pa');
appsec_pa_job.get('name', '[PA AppSec] Daily Data Collection');
if (typeof SncTriggerSynchronizer != 'undefined')
   SncTriggerSynchronizer.executeNow(appsec_pa_job);
else
   Packages.com.snc.automation.TriggerSynchronizer.executeNow(appsec_pa_job);