How can I get a report of all 'report schedules'?
How can I get a report of all 'report schedules' to include their schedule, reciprients and all others fields available?
Thank you.
3 Comments
[ + ] Show comments
-
Thank you for this information but I never heard of Toad and don't know how to write a sql report. - nadecats 7 years ago
-
https://www.quest.com/products/toad-for-mysql/ - SMal.tmcc 7 years ago
-
This is exactly what I needed, thank you very much. - nadecats 7 years ago
Answers (1)
Please log in to answer
Posted by:
SMal.tmcc
7 years ago
You can use toad to get the sql table and columns or write a sql report. the table is Report_Schedule and the columns you mentioned are pictured
Comments:
-
SELECT REPORT_SCHEDULE.ID,
REPORT_SCHEDULE.IM_CRON_ID,
REPORT_SCHEDULE.TITLE,
REPORT_SCHEDULE.DESCRIPTION,
REPORT_SCHEDULE.MESSAGE,
REPORT_SCHEDULE.MODIFIED,
REPORT_SCHEDULE.CREATED,
REPORT_SCHEDULE.NEXT_RUN,
REPORT_SCHEDULE.SUBJECT,
REPORT_SCHEDULE.REPORT_ID,
REPORT_SCHEDULE.FILE_TYPE,
REPORT_SCHEDULE.CC_LIST,
REPORT_SCHEDULE.USER,
REPORT_SCHEDULE.SEND_WHEN_RESULT,
REPORT_SCHEDULE.SMARTY_REPORT,
REPORT_SCHEDULE.LOCALE,
REPORT_SCHEDULE.ATTACHMENT_TYPE,
REPORT_SCHEDULE.REPORT_TYPE,
REPORT_SCHEDULE.USE_TIME_ZONES
FROM ORG3.REPORT_SCHEDULE REPORT_SCHEDULE - SMal.tmcc 7 years ago