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
Admin Script Editor
Admin Script Editor is an integrated scripting environment available free here at ITNinja

Share