Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
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.
