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

Comments

  • Thank you for this information but I never heard of Toad and don't know how to write a sql report.
  • https://www.quest.com/products/toad-for-mysql/
  • This is exactly what I needed, thank you very much.
Please log in to comment

Answers

2
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


Answered 11/14/2016 by: SMal.tmcc
Red Belt

  • 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
Please log in to comment
Answer this question or Comment on this question for clarity