...
Report about Installed Objects
Report about jobs, job chains and orders as collected from disk.
Report about Execution Summary
SELECT <fileds> FROM REPORT_INSTALLED_JOB_OBJECTS('2017-05-01','2017-06-01');
- following fields can be selected:
ID
SCHEDULER_ID
HOSTNAME
JOB_CHAIN
JOB_CHAIN_BASENAME
JOB_CHAIN_TITLE
JOB_NAME
JOB_BASENAME
JOB_TITLE
CAUSE
IS_ACTIVE_CALENDAR
IS_ORDER_JOB
FILE_CREATED
FILE_MODIFIED
- following fields can be selected:
SELECT <fields> FROM REPORT_INSTALLED_ORDER_OBJECTS('2017-05-01','2014-06-01');
- following fields can be selected:
ID
SCHEDULER_ID
HOSTNAME
JOB_CHAIN
JOB_CHAIN_BASENAME
JOB_CHAIN_TITLE
ORDER_ID
ORDER_NAME
ORDER_BASENAME
ORDER_TITLE
CAUSE
IS_ACTIVE_CALENDAR
FILE_CREATED
FILE_MODIFIED
Report about Execution Summary
Report about executions of order jobs and job chains.
SELECT <fields> FROM REPORT_EXECUTION_SUMMARY('2017-05-01','2017-06-01');
- following fields can be selected:
ID
SCHEDULER_ID
HOSTNAME
AGENT_URL
JOB_CHAIN
JOB_CHAIN_BASENAME
JOB_CHAIN_TITLE
JOB_NAME
JOB_BASENAME
JOB_TITLE
CAUSE
IS_ACTIVE_CALENDAR
START_TIME
END_TIME
START_DATE
END_DATE