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
John, could I get a copy as well? Thanks!
jreynolds@clevelandorchestra.com
Just sent to both of you.