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.
Hope this will help!!
Looking forward for everyone's comments and feedback.
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.
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
ReplyDeleteLooks like the essayist has put a considerable measure of diligent work into this.
ReplyDeleteWalmart one wm1 app
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
ReplyDeleteI adore your websites way of raising the awareness on your readers.packwoods la dispensary
ReplyDeleteEasily, 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
ReplyDeleteYou 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
ReplyDeleteWe 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/
ReplyDeleteI can recommend primarily decent and even responsible tips, as a result view it: https://dynamichealthstaff.com/uk-nursing-recruitment-agencies-in-india
ReplyDeletenursing coaching academy
ReplyDeleteThis 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
ReplyDeleteNice! Except you are missing 1 type of report, perhaps the most useful - added to end of jobTypeMap declaration:
ReplyDelete,
'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.
Hello, did you find a way to get the names of the subscribed reports?
Delete