-
problem facing with dbms_scheduler
exec dbms_scheduler.create_job(JOB_NAME=>'TESTING',JOB_TYPE=>'STORED_PROCEDURE',JOB_ACTION=>'TEST1',NUMBER_OF_ARGUMENTS=>1,START_DATE=>TO_TIMESTAMP('19-SEP-2010 16:57:00','DD-MON-YYYY HH24:MI:SS'),END_DATE=>TO_TIMESTAMP('19-SEP-2010 17:05:00','DD-MON-YYYY HH24:MI:SS'),REPEAT_INTERVAL=>'FREQ=HOURLY;BYMINUTE=2',AUTO_DROP=>FALSE);
exec dbms_scheduler.set_job_argument_value('TESTING',1,'16');
EXEC DBMS_SCHEDULER.ENABLE('TESTING');
.............
I have executed the scripts in the above specified format, but i don't know why job didn't get fired.
everything is showing in dba_Schduler_jobs.
am i missed something here.
please help me.
-
Please exec and post...
SELECT * FROM dba_scheduler_jobs WHERE job_name = 'TESTING';
SELECT * FROM dba_scheduler_job_log WHERE job_name = 'TESTING';
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
-
[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
|