Query
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 |
select owner as schema_name, job_name, job_style, case when job_type is null then 'PROGRAM' else job_type end as job_type, case when job_type is null then program_name else job_action end as job_action, start_date, case when repeat_interval is null then schedule_name else repeat_interval end as schedule, last_start_date, next_run_date, state from sys.all_scheduler_jobs order by owner, job_name; |
Columns
- schema_name – name of the schema
- job_name – name of the job
- job_style:
- REGULAR
- LIGHTWEIGHT
- job_type – inline job action type
- PLSQL_BLOCK
- STORED_PROCEDURE
- EXECUTABLE
- CHAIN
- SQL_SCRIPT
- BACKUP_SCRIPT
- EXTERNAL_SCRIPT
- PROGRAM
- job_action – PL/SQL code or program/routine name to call
- start_date – when job will be launched first time
- schedule – inline schedule PL/SQL expression, calendar string or name of the schedule
- last_start_date – last date on which the job started running
- next_run_date: next date on which the job is scheduled to run
- state:
- Disabled
- Scheduled
Rows
- One row: represents one job
- Scope of rows: all jobs in database
- Ordered by job schema, job name