|
-
[QUOTE=PAVB;265813]Please exec and post...
SELECT * FROM dba_scheduler_jobs WHERE job_name = 'TESTING';
SELECT * FROM dba_scheduler_job_log WHERE job_name = 'TESTING';[/QUOTE
DBA_SCHEDULER_JOBS OUTPUT....
JOB_NAME START_DATE JOB_TYPE JOB_ACTION END_DATE REPEAT_INTERVAL STATE ENABL AUTO_
---------- ----------------------------------- -------------------- -------------------- ----------------------------------- ------------------------- --------------- ----- -----
TESTING 19-SEP-10 04.57.00.000000 PM +05:30 STORED_PROCEDURE TEST1 20-SEP-10 05.05.00.000000 PM +05:30 FREQ=HOURLY;BYMINUTE=2 SCHEDULED TRUE FALSE
----------------------------------------------
DBA_SCHEDULER_JOB_LOG:-
NO RECORDS FOR THIS JOB.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|