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,
John, could I get a copy as well? Thanks!
jreynolds@clevelandorchestra.com
Just sent to both of you.
I would need your e-mail address. If you (or anyone else) are uncomfortable sharing here, feel free to just e-mail me directly: jmoskal@thecenterpresents.org.
John A. Moskall II, could I get that view as well?
Clarke Weigle, Florida Studio Theatrecweigle@floridastudiotheatre.org
Sent!
Hi John. I would love a copy of this as well, if you don't mind. TunnellJ@NYPhil.org
Hi John,
Late to the party, could I get a copy of that View also. kelly.enderwick@zsl.org
Thank you!
Kelly
Sorry; was off yesterday. Sending an e-mail now.
Thank you!!!