- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-13-2023 05:39 AM
Can I use a scheduled job to delete old reports?
We have a lot of users creating reports (+1000 per year) that are used only a few times and abandoned.
I want to write a script that will delete reports once they are not run in 18 months.
Report Statistics will tell me the last time a report was run.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-13-2023 12:03 PM
Flow designer is easy way to do.
I created for change , you can create for Scheduled job table and Look up records and do for Each, delete record.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-13-2023 11:31 PM
Hi @ChrisTreichel ,
You can either utilize flow designer as suggested by @Dr Atul - LNG, or you can create a scheduled script to look at the last run date in the sys_report. Please note, than some reports maybe only utilized once or twice a year and could still be needed. So you need to be sure of your condition so you don't delete anything my mistake.
If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.
best regards
Anders
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-13-2023 11:31 PM
Hi @ChrisTreichel ,
You can either utilize flow designer as suggested by @Dr Atul - LNG, or you can create a scheduled script to look at the last run date in the sys_report. Please note, than some reports maybe only utilized once or twice a year and could still be needed. So you need to be sure of your condition so you don't delete anything my mistake.
If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.
best regards
Anders
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-14-2023 04:17 AM
Thank you