Hello Everyone,
I'm in the process of cleaning up our organization's scheduled reports schedule. Is there a way to export a list of all scheduled reports and their details: schedule name, report, status, user ID, user group, and schedule description?
Thank you,
Joseph
Joseph,
I am not aware of any way to do that inside the application, but if you have someone with SQL access, I do have a handy VIEW that I created which outputs the following pieces of information for all actively scheduled reports: schedule ID, report name, date of next running, time of next running, owner user ID, report user group, e-mail subject and e-mail recipients. We use it as a kind of system table so people can see when other reports are scheduled and make sure not to overlap scheduled reports so as to aid in the prevention of scheduled report errors.
John A. Moskal II
Thank you! That's exactly what I'm looking for. My colleague Ashley has SQL access. In fact, I think you recently emailed her some code. Can you please send that VIEW to either Ashley or me. jalderson@granadasb.org
Thank you again,