Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> DBMS_JOB simple question (I think ...)

DBMS_JOB simple question (I think ...)

From: Ricardo Santos <saints.richard_at_gmail.com>
Date: Mon, 26 Nov 2007 16:39:47 +0000
Message-ID: <34e16fec0711260839g43602a50q22e34bf05c98a28f@mail.gmail.com>


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
Received on Mon Nov 26 2007 - 10:39:47 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US