Displays information about all scheduled jobs

SET LINESIZE 500
SET PAGESIZE 1000
SET VERIFY OFF

SELECT a.job “Job”,
Substr(a.log_user,1,15) “Log User”,
Substr(a.priv_user,1,15) “Priv User”,
Substr(a.schema_user,1,15) “Schema User”,
Substr(To_Char(a.last_date,’DD-Mon-YYYY HH24:MI:SS’),1,20) “Last Date”,
Substr(To_Char(a.this_date,’DD-Mon-YYYY HH24:MI:SS’),1,20) “This Date”,
Substr(To_Char(a.next_date,’DD-Mon-YYYY HH24:MI:SS’),1,20) “Next Date”,
a.total_time “Total Time”,
a.broken “Broken”,
a.interval “Interval”,
a.failures “Failures”,
a.what “What”,
a.nls_env “NLS Env”,
a.misc_env “Misc Env”
FROM dba_jobs a;

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: