ALL_SCHEDULER_REMOTE_JOBSTATE

ALL_SCHEDULER_REMOTE_JOBSTATE displays information about the state of the jobs accessible to the current user at remote databases.

Related Views

DBA_SCHEDULER_REMOTE_JOBSTATE displays information about the state of all jobs at remote databases.
USER_SCHEDULER_REMOTE_JOBSTATE displays information about the state of the jobs owned by the current user at remote databases. This view does not display the OWNER column.

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
`DESTINATION`	`VARCHAR2(512)`	`NOT NULL`	Name of the job destination
`STATE`	`VARCHAR2(15)`		State of the job at the destination: `DISABLED` `RETRY SCHEDULED` `SCHEDULED` `RUNNING` `COMPLETED` `BROKEN` `FAILED` `SUCCEEDED` `STOPPED`
`NEXT_START_DATE`	`TIMESTAMP(6) WITH TIME ZONE`		Next start date of the job at the destination
`RUN_COUNT`	`NUMBER`		Run count of the job at the destination
`FAILURE_COUNT`	`NUMBER`		Failure count of the job at the destination
`RETRY_COUNT`	`NUMBER`		Retry count of the job at the destination
`LAST_START_DATE`	`TIMESTAMP(6) WITH TIME ZONE`		Last start date of the job at the destination
`LAST_END_DATE`	`TIMESTAMP(6) WITH TIME ZONE`		Last end date of the job at the destination