Friday, August 24, 2018

Way to get list of Scheduled reports and Jobs from Salesforce

This is very common ask from business admins or end users to get list of schedule reports or schedule jobs (batch jobs, scheduled jobs etc) from Salesforce.

There is no standard view provided by Salesforce to view list of scheduled reports or reports. Users have to navigate to Monitor section under SetUp.


This section display list of jobs either schedule or completed jobs but does not provide complete list of jobs.

By using apex, you get the list of schedule reports or jobs in csv format via email. 

Please find below the apex code for that:


Now if you have to get list of scheduled reports in your org, then just execute below script in developer console:

  • For getting list of scheduled reports:         SK_ScheduleJobUtility.findScheduledJobDetails('Report Run');

  • For getting list of scheduled batch jobs:         SK_ScheduleJobUtility.findScheduledJobDetails('Batch Job');

  • For getting list of scheduled apex jobs:        SK_ScheduleJobUtility.findScheduledJobDetails('Scheduled Apex');


Important Use case

Sometime reports are scheduled by user which becomes inactive, then all system admin start getting email saying:

"The user account that runs the report (the running user) is inactive."

This utility will send email along with user details which will help in identifying all inactive user for whom reports are scheduled as running user.


Hope this will help!!

Looking forward for everyone's comments and feedback.

12 comments:

  1. I found so many interesting stuff in your blog especially its discussion. From the tons of comments on your articles, I guess I am not the only one having all the enjoyment here! keep up the good work... core-functional resume format

    ReplyDelete
  2. Looks like the essayist has put a considerable measure of diligent work into this.
    Walmart one wm1 app

    ReplyDelete
  3. Start your job search on Monster jobs. Browse 1458 employment opportunites in Anchorage, AK on our job search engine. Apply now for jobs hiring near you. jobs in anchorage alaska

    ReplyDelete
  4. I adore your websites way of raising the awareness on your readers.packwoods la dispensary

    ReplyDelete
  5. Easily, the article is actually the best topic on this registry related issue. I fit in with your conclusions and will eagerly look forward to your next updates. getting a new job fast

    ReplyDelete
  6. You there, this is really good post here. Thanks for taking the time to post such valuable information. Quality content is what always gets the visitors coming. aesthetic training institute

    ReplyDelete
  7. We have sell some products of different custom boxes.it is very useful and very low price please visits this site thanks and please share this post with your friends. yourvirtualofficelondon.co.uk/mail-forwarding-london/

    ReplyDelete
  8. I can recommend primarily decent and even responsible tips, as a result view it: https://dynamichealthstaff.com/uk-nursing-recruitment-agencies-in-india

    ReplyDelete
  9. This is a smart blog. I mean it. You have so much knowledge about this issue, and so much passion. You also know how to make people rally behind it, obviously from the responses. jobs recruiting

    ReplyDelete
  10. Nice! Except you are missing 1 type of report, perhaps the most useful - added to end of jobTypeMap declaration:

    ,
    'Reporting Notification' => 'A'

    This allows you to execute the command

    SK_ScheduleJobUtility.findScheduledJobDetails('Reporting Notification');

    to find all scheduled reports sent to users via email (see https://developer.salesforce.com/docs/atlas.en-us.api.meta/api/sforce_api_objects_cronjobdetail.htm)

    Now could you figure out how to send the Names of the reports and their other related details? The cron jobs just return a hex string so it's not very useful to figure out what actual reports are being run by each cron job ID.

    ReplyDelete
    Replies
    1. Hello, did you find a way to get the names of the subscribed reports?

      Delete