Sunday , November 2 2025

Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux

How Can I See Running Job In Oracle Database

Buğra PARLAYAN February 9, 2023 ORACLE

We can see Running Job in Oracle Database using below code block.

SELECT JOB_NAME,
         comments,
         job_Action,
         last_start_date,
         last_run_duration,
         state
    FROM dba_scheduler_jobs
   WHERE state = 'RUNNING'
ORDER BY last_start_date DESC;

SELECT JOB_NAME,

comments,

job_Action,

last_start_date,

last_run_duration,

state

FROM dba_scheduler_jobs

WHERE state = 'RUNNING'

ORDER BY last_start_date DESC;

About Buğra PARLAYAN

Burgra Parlayan is an experienced Database and Weblogic Administrator. After completing his technical / relevant training he has got involved with a serious amount of projects. He successfully managed database upgrade, database migration, database performance tuning projects for various public institutions.Currently he has been employed by one of the leading financial institutions called Turkiye Hayat & Emeklilik as responsible administrator for Oracle Database and Oracle Middleware. He has been sharing his experience and knowledge by face to face training, personal blog and various social networking accounts to support the Oracle ecosystem continuously since 2010.

How Can I See Running Job In Oracle Database

About Buğra PARLAYAN

Leave a Reply Cancel reply