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.
