Home » SQL & PL/SQL » SQL & PL/SQL » run monthly script automatically
run monthly script automatically [message #207245] Mon, 04 December 2006 17:42 Go to next message
kdt2006
Messages: 3
Registered: November 2006
Junior Member
hi

pretty new to oracle. Was wondering if there was a way to run a script i have created for tax on payday every month automatically. Can someone please let me know if this is possible and point me in the right direction.

thanks
Re: run monthly script automatically [message #207246 is a reply to message #207245] Mon, 04 December 2006 18:06 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
In 10g, you should consider using the Scheduler and for 9i you can use DBMS_JOB.

Natalka Roshak also provides nice example articles for Scheduler and DBMS_JOB.

[Updated on: Mon, 04 December 2006 18:11]

Report message to a moderator

Re: run monthly script automatically [message #207447 is a reply to message #207246] Tue, 05 December 2006 11:09 Go to previous message
kdt2006
Messages: 3
Registered: November 2006
Junior Member
your a star

thanx Smile
Previous Topic: Performance issue with indexing
Next Topic: Trigger calls Java Class
Goto Forum:
  


Current Time: Fri Dec 09 17:36:41 CST 2016

Total time taken to generate the page: 0.23013 seconds