Re: DBMS_JOB.SUBMIT

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Sat, 20 Nov 1999 00:25:46 +0800
Message-ID: <38357A0A.7886@yahoo.com>

jwagans4053_at_my-deja.com wrote:
>
> Hello ...
>
> I submit a job to run nightly... when I check sys.dba_jobs;
> it appears to be running. the procedure it submits is in the same
> package as the submit proc. However the submitted proc does not perform
> what it is designed to do. I have ran it on its own and it runs fine .
> the cmd Im using for the submit proc is as follows:
>
> EXEC PA_PURGE_TIME_RECORDS.SP_SUBMIT_TIME_PURGE_JOB
> the code is this:
>
> v_run_date DATE := TRUNC(SYSDATE) + (22+30/60)/24; -- 1030pm
>
> DBMS_JOB.SUBMIT(v_JobNum, -- Return of job number
> 'SP_DELETE_TIME_RECORDS;', -- Procedure to submit
> v_run_date, -- Next date/time to run
> 'sysdate + 1'); -- Interval
>
> any suggestions ??
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.

Make sure you commit after you submit the job... --

---

Connor McDonald
"These views mine, no-one elses etc etc" connor_mcdonald_at_yahoo.com

"Some days you're the pigeon, and some days you're the statue." Received on Fri Nov 19 1999 - 10:25:46 CST