Answers for "dbms_scheduler list jobs"

SQL

4

dbms_scheduler list jobs

SELECT OWNER, JOB_NAME, ENABLED, JOB_CLASS, NEXT_RUN_DATE
FROM DBA_SCHEDULER_JOBS
WHERE OWNER NOT IN ('SYS')
ORDER BY ENABLED, OWNER, JOB_NAME;

-- Running jobs:
SELECT OWNER, JOB_NAME, JOB_SUBNAME, JOB_STYLE, SESSION_ID, SLAVE_PROCESS_ID, 
	ELAPSED_TIME, CPU_USED 
FROM DBA_SCHEDULER_RUNNING_JOBS
ORDER BY OWNER, JOB_NAME;

Posted by: Guest on July-26-2021

Source

Code answers related to "dbms_scheduler list jobs"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Python

Javascript

Whatever

Shell/Bash

CSS

Html

PHP

SQL

Java

C#