Can anyone tell me if/where the email addresses for email recipients of scheduled reports lives? I've found gooesoft_report_schedule, but I need to also know who is getting those that are scheduled to send PDFs.
Thank you!
Frannie
It's a little weird the way this works -- there exists a "master" request for the schedule where your email settings are stored, and this is also where any modifications are made. You may have noticed that if you change the destination email addresses on a schedule report, this doesn't take effect until the SECOND next scheduled run. This is because the next scheduled request is never touched -- instead, when it runs, the report server schedules the next instance of the report according to the stored "master" settings.
GOOESOFT_REPORT_SCHEDULE is where you start -- use this to identify your scheduled report and the request_id of the "master" request; call this <id_master>.
GOOESOFT_REQUEST is where you'd look next, WHERE id = <id_master>. This is where your email settings are stored.
If you want to update the currently scheduled email to avoid waiting until the following run, look in GOOESOFT_SCHEDULE_QUEUE by schedule_id. You should see entries with status 'c' for complete, and one entry with status 's' - scheduled, for your schedule_id. Call this <id_scheduled>. There will not be an entry for the <id_master> in this table.
Then, you'd run:
UPDATE gooesoft_request SET email_recipients = ( SELECT email_recipients FROM gooesoft_request WHERE id = <id_master> ) WHERE id = <id_scheduled>
so much helpful info! Thank you Nick!
I have never known and never tried to figure out why it took one cycle for changes to scheduled reports to be made! Bonus mystery solved.