Oracle教程 2023-02-28

Oracle 视图 ALL_SCHEDULER_REMOTE_JOBSTATE 官方解释，作用，如何使用详细说明

ALL_SCHEDULER_REMOTE_JOBSTATE视图用于存储远程作业状态（在网络上对另一台计算机上的作业进行操作时）的信息。此外，它还提供有关运行作业和作业端口（remote job ports）的信息。

使用ALL_SCHEDULER_REMOTE_JOBSTATE视图，可以查询运行远程作业的状态，查看每个作业执行时间，检查作业完成状态以及计算机名称等。要使用此视图，需要具备 “MANAGE SCHEDULER” 权限。

例如：

SELECT * FROM ALL_SCHEDULER_REMOTE_JOBSTATE where remote_port = ‘port_123’;

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(128)`	`NOT NULL`	Owner of the Scheduler job
`JOB_NAME`	`VARCHAR2(128)`	`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