Home » SQL & PL/SQL » SQL & PL/SQL » Procedure
Procedure [message #306453] Fri, 14 March 2008 05:43 Go to next message
ramya29p
Messages: 100
Registered: November 2007
Location: Chennai
Senior Member
Hi,
i need to execute a procedure on every monday at 9am.
can anyone please tell me how to achieve it?
Re: Procedure [message #306455 is a reply to message #306453] Fri, 14 March 2008 05:51 Go to previous messageGo to next message
dhananjay
Messages: 635
Registered: March 2002
Location: Mumbai
Senior Member
search for DBMS_JOB / DBMS_SCHEDULER.


regards,
Re: Procedure [message #306456 is a reply to message #306453] Fri, 14 March 2008 05:57 Go to previous message
pablolee
Messages: 2834
Registered: May 2007
Location: Scotland
Senior Member
Make sure that you get in early enough Smile
Alternatively you could lookup the documentation on DBMS_SCHEDULER.

Beaten to it

[Updated on: Fri, 14 March 2008 05:57]

Report message to a moderator

Previous Topic: UTL_MAIL PROBLEM
Next Topic: checking concesutive record's dates to find whether it completed within 3 days (merged)
Goto Forum:
  


Current Time: Sat Dec 03 12:15:17 CST 2016

Total time taken to generate the page: 0.06425 seconds