Re: Scheduling Stored Procedures

wpp289 wrote:
> Greetings,
>
> I'm relatively new to stored procedures, is it possible to schedule
> these to run, say daily, within the DBMS, or is a
> call from an external app required?
>
> Thanking any kind soul in advance for their assistance.
>
> Bill P.
>

dbms_job package

Example run ever 10 minutes, first time in 20 seconds

VARIABLE jobno number;
begin

   DBMS_JOB.SUBMIT(:jobno, 'CheckBroadcast;', SYSDATE+20/86400, 'SYSDATE+1/288');
   commit;
end;
/

--

every day: use SYSDATE+1
this however leads to a slow shifting of the sceduled time.

Used
TRUNC(SYSDATE + 1, 'DD') +  000023.8333333333/24
for instance to start 5 minutes before midnight