Re: How Do I Schedule An SQL Query To Take Place On A Daily Basis?

From: andrew_webby at hotmail <spam_at_no.thanks.com>
Date: Thu, 14 Dec 2000 15:08:28 -0000
Message-ID: <976806549.13115.0.nnrp-02.c30bdde2@news.demon.co.uk>

Should be fine.

Personally, I prefer cron for running jobs as they're easier to 'get at' if you want to delete or disable them etc...

<ras117_at_my-deja.com> wrote in message news:915bml$cdn$1_at_nnrp1.deja.com...
> Hey I'm setting off a procedure to run midnight with the following.
> However I am not sure if this would work.
>
> VARIABLE V_JOBNUM NUMBER;
> BEGIN
> DBMS_JOB.SUBMIT(:V_JOBNUM,'UPDATEMAILDROP;',ROUND(SYSDATE),'SYSDATE+1');
> COMMIT;
> END;
>
> Where the procedure name is updatemaildrop, the first time the procedure
> should start is at midnight today. I am not too sure if it will do it
> again at midnight the next day 'though.
>
> Comment welcome.
>
>
> Thanks
>
> Raihan Sarker
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Thu Dec 14 2000 - 09:08:28 CST