OraFAQ Forum: Server Administration » Schedule a procedure

Home » RDBMS Server » Server Administration » Schedule a procedure

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Schedule a procedure [message #151939]

Mon, 19 December 2005 23:20

vivekmenon_k
Messages: 9
Registered: March 2005
Location: India

Junior Member

I want to schedule a procedure to run every day at 5.30 am, How can it be done.

Report message to a moderator

Re: Schedule a procedure [message #151972 is a reply to message #151939]

Tue, 20 December 2005 03:09

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Search for DBMS_JOB in this forum / google.
Use dbms_job to schedule the procedure to run within oracle.
or
use a shell script/ batch script to wrap the procedure and schedule it from OS scheduler.

Report message to a moderator

Re: Schedule a procedure [message #152029 is a reply to message #151939]

Tue, 20 December 2005 09:58

rigatonip
Messages: 50
Registered: December 2005

Member

Look up the DBMS_JOBS package. Something like this should do what you want. Run it from SQL*PLUS. Substitute your procedure name for proc1.

VARIABLE jobno number;

begin

DBMS_JOB.SUBMIT(
:jobno,
'proc1',
sysdate,
'TRUNC(SYSDATE) + 5.5/24');

commit;
end;

Report message to a moderator

Previous Topic:	How To Find User quota
Next Topic:	Revoke query

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jan 25 10:02:54 CST 2025