10

Is there any way to get a list of all scheduled reports and the schedule they run on? I can get a list of reports under Monitoring > Scheduled Jobs, but that doesn't show me the schedule they run on. I have to click through to the report and then schedule future runs to see the current schedule.

The CronTrigger object seems to be the closest I can get, but as has been noted in the past, that object doesn't have a name or really any way to identify what Apex class or report is scheduled.

I don't think there is a way based on this idea on IdeaExchange, but hoping someone has some tricks up their sleeve.

  • Your post made me curious so I did some searching around my Dev Org this morning. Didn't find anything conclusive, but saw a couple things you might want to explore. One thought was to query off the QueueSobject for CronTrigger__r, etc if QueueSobject is what it sounds like. The others were to query off Document in a similar manner since the reports have to be created and are stored as Documents in Folders. Just a couple ideas that may be worth exploring further... – crmprogdev Jun 29 '13 at 15:18
  • Did you try AsyncApexJob API Object ? – Cloud Ninja Aug 13 '13 at 6:32
4

Looks like Winter '14 Release now makes this possible by giving you access to the CronJobDetail object from the CronTrigger object:

SELECT Id, CronJobDetail.Id, CronJobDetail.Name, CronJobDetail.JobType, StartTime, EndTime, CronExpression
FROM CronTrigger

Your Answer

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

Not the answer you're looking for? Browse other questions tagged or ask your own question.