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.

9 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. This is also a very good post which I really enjoyed reading. It is not every day that I have the possibility to see something like this..
    Jobs

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

    ReplyDelete
  6. I am looking for and I love to post a comment that "The content of your post is awesome" Great work!
    먹튀토토사이트

    ReplyDelete
  7. Thanks for the blog loaded with so many information. Stopping by your blog helped me to get what I was looking for.
    solar power

    ReplyDelete
  8. 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