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

Report message to a moderator

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

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Apr 23 06:15:03 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.