Oracle教程 2023-04-01

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

本站中文解释

Oracle ALL_SCHEDULER_JOB_DESTS视图显示了它们在所有SCHEDULER_JOB_DESTS表中定义的每个作业的目的地。此视图不访问用户的表，因此用户无法添加行。

该视图有7列：

OWNER：作业的所有者
JOB_NAME：所拥有的作业的名称
DESTINATION_NAME：目标的名称
DESTINATION_TYPE：目标类型
DESTINATION_DESCRIPTION：目标描述
DESTINATION_ENABLED：标志指示是否启用或禁用目标
DESTINATION_RESTARTABLE：标志指示是否能够重新启动

使用ALL_SCHEDULER_JOB_DESTS视图时，可以使用SELECT语句检索以下内容：

-某个作业的指定目标（或所有目标）
-某类目标（例如，Database，OS，FTP等）的所有目标
-在某个所有者的范围内的所有作业的所有目标
-禁用的目标
-重新启动的目标

官方英文解释

ALL_SCHEDULER_JOB_DESTS displays information about the state of the jobs accessible to the current user at each of their destinations.

Related Views

DBA_SCHEDULER_JOB_DESTS displays information about the state of all jobs in the database at each of their destinations.
USER_SCHEDULER_JOB_DESTS displays information about the state of the jobs owned by the current user at each of their destinations. This view does not display the OWNER column.

Column	Datatype	Description
`OWNER`	`VARCHAR2(128)`	Owner of the Scheduler job
`JOB_NAME`	`VARCHAR2(128)`	Name of the Scheduler job
`JOB_SUBNAME`	`VARCHAR2(128)`	Subname of the Scheduler job
`CREDENTIAL_OWNER`	`VARCHAR2(128)`	Owner of the credential used for the remote destination
`CREDENTIAL_NAME`	`VARCHAR2(128)`	Name of the credential used for the remote destination
`DESTINATION_OWNER`	`VARCHAR2(261)`	Owner of the destination object that points to the destination
`DESTINATION`	`VARCHAR2(261)`	Name of the destination object or the name of the destination itself
`JOB_DEST_ID`	`NUMBER`	Numerical ID assigned to the job at this destination
`ENABLED`	`VARCHAR2(5)`	Indicates whether the parent job is enabled (`TRUE`) or disabled (`FALSE`)
`REFS_ENABLED`	`VARCHAR2(5)`	Indicates whether this destination and its agent are enabled (`TRUE`) or disabled (`FALSE`)
`STATE`	`VARCHAR2(15)`	State of this job at this destination: `DISABLED` `RUNNING` `CHAIN_STALLED` `SCHEDULED` `RETRY SCHEDULED` `READY TO RUN` `COMPLETED` `BROKEN` `FAILED` `SUCCEEDED` `REMOTE` `STOPPED`
`NEXT_START_DATE`	`TIMESTAMP(6) WITH TIME ZONE`	Next start time of this job at this destination
`RUN_COUNT`	`NUMBER`	Number of times this job has run at this destination
`RETRY_COUNT`	`NUMBER`	Number of times this job has been retried at this destination
`FAILURE_COUNT`	`NUMBER`	Number of times this job has failed at this destination
`LAST_START_DATE`	`TIMESTAMP(6) WITH TIME ZONE`	Last time this job started at this destination
`LAST_END_DATE`	`TIMESTAMP(6) WITH TIME ZONE`	Last time this job ended at this destination

本站中文解释

官方英文解释

相关推荐