List all scheduler jobs from Oracle database

List all scheduler jobs from Oracle database

To list all scheduler jobs from Oracle database you can use: USER_SCHEDULER_JOBS, ALL_SCHEDULER_JOBS, DBA_SCHEDULER_JOBS.

Examples

  
SELECT * FROM USER_SCHEDULER_JOBS;

SELECT * FROM ALL_SCHEDULER_JOBS;

SELECT * FROM DBA_SCHEDULER_JOBS;




List all scheduler running jobs from Oracle database: USER_SCHEDULER_RUNNING_JOBS, ALL_SCHEDULER_RUNNING_JOBS, DBA_SCHEDULER_RUNNING_JOBS.

 Examples

  
SELECT * FROM USER_SCHEDULER_RUNNING_JOBS;

SELECT * FROM ALL_SCHEDULER_RUNNING_JOBS;

SELECT * FROM DBA_SCHEDULER_RUNNING_JOBS;