List all scheduler jobs from Oracle database
Oracle PL/SQL provides several views that allow users to view and manage scheduled jobs within the database.
To list all scheduler jobs from Oracle database you can use: USER_SCHEDULER_JOBS, ALL_SCHEDULER_JOBS, DBA_SCHEDULER_JOBS.
USER_SCHEDULER_JOBS view displays all scheduled jobs that are owned by the current user. This view only shows the jobs that the user has the privilege to see.
ALL_SCHEDULER_JOBS view displays all scheduled jobs that are accessible to the current user. This view shows the jobs that the user has access to, including the jobs that the user owns and the jobs that are accessible through roles.
DBA_SCHEDULER_JOBS view displays all scheduled jobs in the entire database. This view is only accessible to users with the DBA role, and shows all jobs in the database, including those owned by other users.
These views can be queried to retrieve information about scheduled jobs, such as the job name, schedule, and status. Users can also use these views to manage their scheduled jobs, for example, by stopping, starting or dropping a job.
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.
SELECT * FROM USER_SCHEDULER_RUNNING_JOBS; SELECT * FROM ALL_SCHEDULER_RUNNING_JOBS; SELECT * FROM DBA_SCHEDULER_RUNNING_JOBS;