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
Bookmarks