Re: DBMS_JOB.SUBMIT

This line is incorrect

v_run_date DATE DEFAULT TO_DATE(SYSDATE||'04:40:00','DD-MON-YY HH24:MI:SS'); -- 04:00AM

   It should be
v_run_date DATE DEFAULT TO_DATE(TRUNC(SYSDATE)||'04:40:00','DD-MON-YY HH24:MI:SS'); -- 04:00AM

Hth,

Sybrand Bakker, Oracle DBA

<jwagans4053_at_my-deja.com> wrote in message news:7pjrcm$su9$1_at_nnrp1.deja.com...
> 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 - 12:42:17 CDT