HIRE ORACLE DBA IN ABU DHABI
ORACLE DBA JOBS DUBAI
Tuesday, June 3, 2014
Script to find in oracle 10g to Displays scheduler job information.
SET LINESIZE 200
COLUMN owner FORMAT A20
COLUMN next_run_date FORMAT A35
SELECT owner,
job_name,
enabled,
job_class,
next_run_date
FROM
dba_scheduler_jobs
ORDER BY owner, job_name;
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment