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: 2844
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 Feb 25 07:52:31 CST 2017

Total time taken to generate the page: 0.10583 seconds