A selection of topics on IT and its application to finance.
Send me your comments, questions or suggestions by clicking here
A very quick introduction to using the Oracle Scheduler
The first thing to do is to set up a schedule. Here you name the schedule, define it's starting and ending dates and also any repeat interval you require, e.g every 5 minutes, every day etc ...and so on.
Next you need to set up the program you want to do the work you want done. This can be a piece of PL/SQL, an existing stored procedure or an external executable.
Lastly you must define a job which basically pulls together the above two strands. The job will state what is to run (i.e which program) and when it is to run (i.e which schedule it is to follow). When you are happy that the above are all defined to your liking, simpy ensure both the job and program are enabled and the schedule will then be activated.