Answers for "scheduler oracle"

SQL
3

oracle scheduler program list

-- Depending on connected user grants:
SELECT * FROM ALL_SCHEDULER_PROGRAMS ORDER BY OWNER, PROGRAM_NAME;
SELECT * FROM DBA_SCHEDULER_PROGRAMS WHERE OWNER = 'schema_name';
SELECT * FROM USER_SCHEDULER_PROGRAMS;
Posted by: Guest on July-06-2021
4

oracle job scheduler

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

Code answers related to "SQL"

Browse Popular Code Answers by Language