Why my Scheduler Not launch my Job ?
917989Feb 16 2012 — edited Feb 22 2012I can find no solution to this problem, all help will be welcome.
I want to execute a simple job with dbms.scheduler (job launch stored procedure).
if my start date is set to less than 14 minutes, the schedule launch the job and the state is display "succeed" (i can see the result with the request : select job_name,state,start_date from dba_scheduler_jobs).
If i plannified a job that exceeds the fiveteen minutes (startdate) , then scheduler not running (state stay scheduled indefinitely)
I make the test on two different server (AIX and windows) and the result is identical
I see no error who explain this problème
Thank you in advance for your help
I use :
Oracle 10gr2
job_queue_processes = 100
systimestamp = 16/02/2012 14:52:52,562000000 +01:00
current_timestamp= 16/02/2012 14:52:52,562000000 +01:00
localtimestamp = 16/02/2012 14:52:52,562000000
MAX_JOB_SLAVE_PROCESSES=NULL
logins = ALLOWED ( select logins from v$instance)
I create the scheduler with sql developper (but with a another software the result is identical)
-------------
BEGIN DBMS_SCHEDULER.create_program ( program_name => 'UFDPARAM.P1', program_action => 'ACTION_CHGTAU', program_type =>'STORED_PROCEDURE', number_of_arguments=> 1, enabled => FALSE, comments => ' PRG ITF CHG TAUX');
dbms_scheduler.DEFINE_PROGRAM_ARGUMENT( program_name=> ' UFDPARAM.P1', argument_position=> 1, argument_type=> 'VARCHAR2', DEFAULT_VALUE=>'0'); dbms_scheduler.enable('UFDPARAM.P1'); END;
--
BEGIN DBMS_SCHEDULER.create_schedule ( schedule_name => 'UFDPARAM.S1', start_date => TIMESTAMP '2012-02-16 10:52:00 Europe/Paris', repeat_interval => NULL, end_date => NULL, comments => 'SCHEDULE ITF CHG TAUX');END;
--
BEGIN dbms_scheduler.create_job( job_name => 'J1', program_name => 'P1', schedule_name => 'S1', job_class => 'DEFAULT_JOB_CLASS', auto_drop => FALSE, comments => 'JOB ITF CHG TAUX');
dbms_scheduler.set_job_argument_value('UFDPARAM.J1',1,'00013607201001181931110000');
dbms_scheduler.enable('UFDPARAM.J1'); END;