Re: Problem while scheduling Jobs

I'm not too sure about the error that is being raised: (maybe the string new_date, doesn't look like dd-mm-yyyy'), (you can put an exception handler in your function and that will prevent errors being written to the the alert log),

but If you want to dynamically re-schedule a job in the job queue, I think you do it this way:
  . create the function or procedure with an in-out date parameter, eg.

     myproc(next_date_in_out IN OUT DATE);  . inside the procedure: set the in out parameter to the next time you want the job to run,

    next_date_in_out := sysdate + 10;
. insert the procedure into the jobq using the key-word next_date:

   dbms_job.submit(:job,myproc (next_date);,... Received on Fri Jul 07 2000 - 11:08:47 CDT