DBMS_JOB.SUBMIT

I would like to create a proc that allows you to submit a job on the fly, and run at 4am on that day. Then have the job resubmit itself on saturday next at 4am. this is what I came up with but I get a -23319 err I believe it is related to v_nxtdate. I have not seen anything that says you cant use varibles.
Help!!

CREATE OR REPLACE PROCEDURE Saturday

• Description: This stored procedure will submit a DBMS_JOB for the TOME sys -- runs
• every Sat night at 4:00AM. IS v_JobNum BINARY_INTEGER; v_run_date DATE DEFAULT TO_DATE(SYSDATE||'04:40:00','DD-MON-YY HH24:MI:SS'); -- 04:00AM v_nxtdate DATE;
  --
  BEGIN v_nxtdate := next_day((v_run_date + 7), 'Saturday');
  --
  DBMS_JOB.SUBMIT(v_JobNum, -- Return of job number 'Satins;', -- Procedure to submit v_run_date, -- Next date/time to run v_nxtdate); -- Interval of next day
  --
  END Saturday; /

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Fri Aug 20 1999 - 10:14:43 CDT