DBA_SCHEDULER_JOB_ROLES

DBA_SCHEDULER_JOB_ROLES displays information about all Scheduler jobs in the database by database role.

Column	Datatype	NULL	Description
`OWNER`	`VARCHAR2(30)`	`NOT NULL`	Owner of the Scheduler job
`JOB_NAME`	`VARCHAR2(30)`	`NOT NULL`	Name of the Scheduler job
`JOB_SUBNAME`	`VARCHAR2(30)`		Subname of the Scheduler job (for a job running a chain step)
`JOB_CREATOR`	`VARCHAR2(30)`		Creator of the Scheduler job
`DATABASE_ROLE`	`VARCHAR2(16)`		Name of the database role
`PROGRAM_OWNER`	`VARCHAR2(4000)`		Owner of the program associated with the job
`PROGRAM_NAME`	`VARCHAR2(4000)`		Name of the program associated with the job
`JOB_TYPE`	`VARCHAR2(16)`		Inline job action type: `PLSQL_BLOCK` `STORED_PROCEDURE` `EXECUTABLE` `CHAIN`
`JOB_ACTION`	`VARCHAR2(4000)`		Inline job action
`JOB_CLASS`	`VARCHAR2(30)`		Name of the job class associated with the job
`SCHEDULE_OWNER`	`VARCHAR2(4000)`		Owner of the schedule that the job uses (can be a window or a window group)
`SCHEDULE_NAME`	`VARCHAR2(4000)`		Name of the schedule that the job uses (can be a window or a window group)
`SCHEDULE_TYPE`	`VARCHAR2(12)`		Type of the schedule that the job uses: `IMMEDIATE` - Start date and repeat interval are NULL `ONCE` - Repeat interval is NULL `PLSQL` - PL/SQL expression used as schedule `CALENDAR` - Oracle calendaring expression used as schedule `EVENT` - Event schedule `NAMED` - Named schedule `WINDOW` - Window used as schedule `WINDOW_GROUP` - Window group used as schedule
`START_DATE`	`TIMESTAMP(6) WITH TIME ZONE`		Original scheduled start date of the job (for an inline schedule)
`REPEAT_INTERVAL`	`VARCHAR2(4000)`		Inline schedule PL/SQL expression or calendar string
`END_DATE`	`TIMESTAMP(6) WITH TIME ZONE`		Date after which the job will no longer run (for an inline schedule)
`LAST_START_DATE`	`TIMESTAMP(6) WITH TIME ZONE`		Last date on which the job ran
`ENABLED`	`VARCHAR2(5)`		Indicates whether the job is enabled (`TRUE`) or disabled (`FALSE`)
`STATE`	`VARCHAR2(15)`		Current state of the job: `DISABLED` `RETRY SCHEDULED` `SCHEDULED` `RUNNING` `COMPLETED` `BROKEN` `FAILED` `REMOTE` `SUCCEEDED` `CHAIN_STALLED`
`COMMENTS`	`VARCHAR2(240)`		Comments on the job