Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Why my Scheduler Not launch my Job ?

917989Feb 16 2012 — edited Feb 22 2012
I 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;
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 21 2012
Added on Feb 16 2012
1 comment
199 views