[SalesForce] How to See Scheduled Job Run History

I have a scheduled job that is supposed to run every night at midnight. Recently users have said that the job didn't run; however this is sporadic, some nights it works and others it doesn't.

Is there a way for me to see scheduled job run history? I'm hoping to be able to verify either that it didn't run or that it did run and the code just didn't do what was expected.

Looking at the scheduled jobs page in setup, it appears I can see the last time it ran from the 'Started' column, but I'm looking for a comprehensive list of all the runs so I can verify it either ran or didn't on days the users saw issues.

If not I'm thinking I'll have to wait until the day they notice the issue again and then look at the scheduled jobs page to see if it ran last night or not.

Best Answer

Here is the query I run in workbench, or you can use dev console as well.

SELECT CronJobDetail.Name, cronjobdetail.JobType ,
  CreatedBy.name,CronExpression,EndTime,Id, 
  NextFireTime,PreviousFireTime,StartTime,State, TimesTriggered FROM 
  CronTrigger 
  where cronjobdetail.JobType = '7'
  or cronjobdetail.JobType = '9'
  order by PreviousFireTime desc limit 25

You can get the types on the dev page for CronJobDetail. I was looking for just scheduled apex and batch jobs. This does not give you entire history and I don't know if that is possible but it give a lot of information that may help you answer your question.

https://developer.salesforce.com/docs/atlas.en-us.218.0.api.meta/api/sforce_api_objects_cronjobdetail.htm

Related Solutions

[SalesForce] Scheduled Job Does Not Seem To Be Running

I haven't seen that but when I am debugging scheduled batches, I typically schedule it via the dev console to run in 2 minutes time, and then watch the logs - even if if something isn't written to the jobs queue, you should see it in the logs for the running user (which would be you if created via Dev Console)

[SalesForce] Need System.schedule cron string for run once

You can do either option (both are viable).

To specify a run-once schedule, specify a fully qualified date and time, such as:

0 0 0 4 JUL ? 2014
| | | | |   | |
| | | | |   | \------- YEAR (2014)
| | | | |   \--------- DAY_OF_WEEK (NOT_SPECIFIED)
| | | | \------------- MONTH (JULY)
| | | \--------------- DAY_OF_MONTH (4th)
| | \----------------- HOUR (0- MIDNIGHT LOCAL TIME)
| \------------------- MINUTE (0)
\--------------------- SECOND (0)

This would run at midnight of the scheduling user on the Fourth of July this year, and never again.

If you want to kill other jobs, you simply query for scheduled jobs that are not already cancelled, and then call System.abortJob on those ID values. See CronTrigger for more information.

Finally, you can also abort the current job in the execute() method:

public void execute(SchedulableContext sc) {
    // Do stuff here
    System.abortJob(sc.getTriggerId());
}

Best Answer

Related Solutions

[SalesForce] Scheduled Job Does Not Seem To Be Running

[SalesForce] Need System.schedule cron string for run once

Related Topic