Oracle教程 2023-02-27

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

本站中文解释

ALL_SCHEDULER_JOB_RUN_DETAILS视图提供了最近定期任务运行的所有详细信息。该视图包含定期任务的步骤名称、开始和结束时间、实际估计运行时间、参数等数据。

使用Oracle视图ALL_SCHEDULER_JOB_RUN_DETAILS可以获取以下数据：

– 步骤：可以通过在JOB_NAME和JOB_SUB_NAME列中搜索您的特定Job或步骤名称来查找Job或步骤
– 运行否：在运行完Job或步骤后，在失败、成功或取消列中查看它是否被运行
– 时间：通过组合查询来获得定期任务的执行次数，启动时间，完成时间和执行持续时间
– 参数：可以在Args、Actual_Start_Date、Start_Date和End_Date列组合查询来查看定期任务的自定义参数

官方英文解释

ALL_SCHEDULER_JOB_RUN_DETAILS displays log run details for the Scheduler jobs accessible to the current user.

Related Views

DBA_SCHEDULER_JOB_RUN_DETAILS displays log run details for all Scheduler jobs in the database.
USER_SCHEDULER_JOB_RUN_DETAILS displays log run details for the Scheduler jobs owned by the current user.

Column	Datatype	NULL	Description
`LOG_ID`	`NUMBER`	`NOT NULL`	Unique identifier of the log entry (foreign key of the `*_SCHEDULER_JOB_LOG` views)
`LOG_DATE`	`TIMESTAMP(6) WITH TIME ZONE`		Date of the log entry
`OWNER`	`VARCHAR2(128)`		Owner of the Scheduler job
`JOB_NAME`	`VARCHAR2(261)`		Name of the Scheduler job
`JOB_SUBNAME`	`VARCHAR2(261)`		Subname of the Scheduler job (for a chain step job)
`STATUS`	`VARCHAR2(30)`		Status of the job run
`ERROR#`	`NUMBER`		Error number in the case of an error
`REQ_START_DATE`	`TIMESTAMP(6) WITH TIME ZONE`		Requested start date of the job run
`ACTUAL_START_DATE`	`TIMESTAMP(6) WITH TIME ZONE`		Actual date on which the job was run
`RUN_DURATION`	`INTERVAL DAY(3) TO SECOND(0)`		Duration of the job run
`INSTANCE_ID`	`NUMBER`		Identifier of the instance on which the job was run
`SESSION_ID`	`VARCHAR2(128)`		Session identifier of the job run
`SLAVE_PID`	`VARCHAR2(30)`		Process identifier of the slave on which the job was run
`CPU_USED`	`INTERVAL DAY(3) TO SECOND(2)`		Amount of CPU used for the job run
`CREDENTIAL_OWNER`	`VARCHAR2(261)`		Owner of the credential used for this remote job run
`CREDENTIAL_NAME`	`VARCHAR2(261)`		Name of the credential used for this remote job run
`DESTINATION_OWNER`	`VARCHAR2(261)`		Owner of the destination object used in this remote job run; NULL if no object used
`DESTINATION`	`VARCHAR2(261)`		Destination for a remote job operation
`ADDITIONAL_INFO`	`VARCHAR2(4000)`		Additional information on the job run, if applicable
`ERRORS`	`VARCHAR2(4000)`		Error messages generated by this job run
`OUTPUT`	`VARCHAR2(4000)`		Output messages generated by this job run
`BINARY_ERRORS`	`BLOB`		Error messages generated by this job run in a binary format
`BINARY_OUTPUT`	`BLOB`		Binary output messages generated by this job run

本站中文解释

官方英文解释

相关推荐