Social Buttons

LightBlog

Breaking

LightBlog

samedi 6 juin 2020

Displays scheduler information for running


-- Description : Displays scheduler information for running jobs.


-- -----------------------------------------------------------------------------
------
-- Author : aws-senior.com
-- Description : Displays scheduler information for running jobs.
-- Requirements : Access to the DBA views.
-- Call Syntax : @jobs_running
-- -----------------------------------------------------------------------------
------
SET LINESIZE 200

COLUMN owner FORMAT A20
COLUMN elapsed_time FORMAT A30

SELECT owner,
job_name,
running_instance,
elapsed_time,
session_id
FROM dba_scheduler_running_jobs
ORDER BY owner, job_name;


--------------------------------------------------------------------------------------
-- File Name : https://github.com/Zaalouni/OracleDba
-- Author : Zaalouni
-- website : www.aws-senior.com
-- Github : https://github.com/Zaalouni/OracleDba
--------------------------------------------------------------------------------------

aws-senior.com

aws-senior.com

www.aws-senior.com
Visite out website www.aws-senior.com
http://www.aws-senior.com
www.aws-senior.com -- Description : Displays scheduler information for running jobs.
-- Description : Displays scheduler information for running jobs.
-- Description : Displays scheduler information for running jobs.

Aucun commentaire:

Enregistrer un commentaire

Nombre total de pages vues

Adbox