Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> 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-lReceived on Mon Nov 26 2007 - 10:39:47 CST
![]() |
![]() |