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.