dbms scheduler list jobs

Solutions on MaxInterview for dbms scheduler list jobs by the best coders in the world

Search
showing results for - "dbms scheduler list jobs"
Martina
04 Mar 2016
1SELECT OWNER, JOB_NAME, ENABLED, JOB_CLASS, NEXT_RUN_DATE
2FROM DBA_SCHEDULER_JOBS
3WHERE OWNER NOT IN ('SYS')
4ORDER BY ENABLED, OWNER, JOB_NAME;
5
6-- Running jobs:
7SELECT OWNER, JOB_NAME, JOB_SUBNAME, JOB_STYLE, SESSION_ID, SLAVE_PROCESS_ID, 
8	ELAPSED_TIME, CPU_USED 
9FROM DBA_SCHEDULER_RUNNING_JOBS
10ORDER BY OWNER, JOB_NAME;
source
similar questions
oracle all scheduler programsdbms scheduler stop joboracle create job exampleshow all event schedular on mysqloracle job schedulesoracle dbms scheduler repeat interval every 5 minutesdba scheduler jobs historyoracle show running jobdbms scheduler create job examplems sql how to see active job current run timescheduled mysql database backup in linuxdba jobs historyhow to check all scheduled jobs in oracleoracle scheduler program listdump db only triggers mysqldbms scheduler drop job
queries leading to this page
dbms scheduler running jobsdba scheduler jobsdba schedule jobsdbms scheduler running multiple jobsoracle sql list jobsoracle db jobs listoracle list jobs runningoracle jobsscheduler jobs in oracledbms scheduler list jobsdba scheduler job run details 22connect by 22dbms scheduler exampleoracle sql jobsoracle job schedulesdba scheduler running jobs 22connect by 22oracle job scheduleroracle schedule jobs timeoracle list scheduled jobsjobs at oracleschedule job in oracle sql developeroracle enable scheduled joboracle it jobsoracle compile scheduler jobsdbms scheduler create job examplerun scheduler job manually oraclebest oracle jobsoracle table to see all jobsoracle list jobsdba scheduler jobs runningdbms scheduler drop jobhow to set scheduler job in oracle databasedbms scheduler list jobs