RE: DBMS_JOB simple question (I think ...)

What is your job queue processes variable set to? It needs to be greater than zero for this to work.  

system_at_PROD> edit

Wrote file afiedt.buf  

  1 select name, value from v$parameter

  2* where name like '%job%'

system_at_PROD> /  

NAME                           VALUE

------------------------------ ------------

job_queue_processes            2

 

1 row selected.  

system_at_PROD>  

Sam Bootsma

Oracle Database Administrator

Information Technology Services
George Brown College

Phone: 416-415-5000 x4933
Fax: 416-415-4836
E-mail: sbootsma_at_georgebrown.ca <mailto:sbootsma_at_georgebrown.ca>

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Ricardo Santos Sent: November 26, 2007 11:40 AM
To: oracle-l_at_freelists.org
Subject: DBMS_JOB simple question (I think ...)    

Hello to you all,

Sorry for such a dummy question, but sometimes the simplest things can be the hard ones.

I just want to submit a job to the database to be executed only once at a certain time in future. This job will execute a stored procedure.

This is how I'm doing it:  

DECLARE   X NUMBER;    BEGIN   SYS.DBMS_JOB.SUBMIT     ( job => X

,what => 'NECI_UIAPP_DBO.DUMMY_PROCEDURE;'

,next_date => to_date('26-11-2007 17:00:00','dd/mm/yyyy
hh24:mi:ss')

,no_parse => FALSE

    );  

 COMMIT; END;   I think the user that is submitting the job has the correct grants. It has the CREATE JOB and the EXECUTE grant on DBMS_JOB.  

I don't understand why but my database is not executing the job. Can someone give me an help on this ?       

Thank you all your attention.   

Best Regards,

Ricardo Santos

--
http://www.freelists.org/webpage/oracle-l