Scheduled Job List in Oracle Databases

You can take advantage of the following views to find scheduled jobs and currently running jobs in Oracle databases.

USER_SCHEDULER_JOBS, ALL_SCHEDULER_JOBS, DBA_SCHEDULER_JOBS views can be used for information about user-level and database-level jobs.

USER_SCHEDULER_JOBS: Displays information about scheduled jobs that the current user has.

ALL_SCHEDULER_JOBS: Displays information about scheduled jobs that can be accessed by the current user.

DBA_SCHEDULER_JOBS: Displays information about all scheduled jobs in the database.

USER_SCHEDULER_RUNNING_JOBS, ALL_SCHEDULER_RUNNING_JOBS, DBA_SCHEDULER_RUNNING_JOBS views can be used to get information about currently running jobs at the user and database level.

USER_SCHEDULER_RUNNING_JOBS: Displays information about currently running jobs that the current user has.

ALL_SCHEDULER_RUNNING_JOBS: Displays information about currently running jobs that can be accessed by the current user.

DBA_SCHEDULER_RUNNING_JOBS: Displays information about all currently running jobs in the database.

dbtut
Author: dbtut

We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.

Leave a Reply

Your email address will not be published. Required fields are marked *