This content has been marked as final. Show 1 reply
930414 wrote:If you're getting any results other than error messages, then I don't believe you're really running this code.
This is how my code looks....
DBMS_JOB.submit (jobno, 'begin ' || mysql || '; end;');
Using mysql I m invoking a procedure.When I am executing above block , jobs are getting inserted into dbms_jobs.
But they are not getting executed.In user_jobs table, this_date column is going as NULL.
DECLARE is mis-spelled, and jobno is not declared.
ANy suggestions pleasePost a complete test script that people can run to re-create the problem and test their ideas. Include the CREATE PROCEDURE code for XXXXXXXXXXXX, and some code that checks whether the procedure ran or not.
Why are you using dbms_jobs?
If you want to run a procedure over and over (say, once a day), or at a particular time, then use dbms_scheduler.
If you want to run the procedure just once, right away, then just run the procedure. Don't botherr with either dbms_jobs or dbms_scheduler.