tags:

views:

52

answers:

1
+1  Q: 

Does Oracle Support Events?

MySQL supports events where i can set up something to happen in a specified time period

Eg: Update the salary's every month

Eg: Update something every year

Eg: Change the status of a book to "overdue" in a week

Etc etc etc

How do I do this in Oracle?

+5  A: 

You can use DBMS_SCHEDULER to do perform scheduled events.

Official Documentation: http://download.oracle.com/docs/cd/B28359_01/server.111/b28310/scheduse.htm

Alternate: http://www.comp.dit.ie/btierney/oracle11gdoc/server.111/b28310/scheduse.htm

Sathya  2010-06-20 06:29:14
In 9i or earlier DBMS_JOB does the same thing, only with less flexibility.
APC  2010-06-20 09:24:21
If you're going to provide a link, why not link to the source? http://download.oracle.com/docs/cd/B28359_01/server.111/b28310/scheduse.htm
Pop  2010-06-20 14:02:45
@Pop: I seemingly couldn't find it, thanks I've updated the answer.
Sathya  2010-06-20 19:10:26

related questions

Specifying the running directory for Scheduled Tasks using schtasks.exe
How do you schedule a daily script run on Windows XP?
How to develop a Windows scheduled task?
windows service vs scheduled task
How do you handle scheduled tasks for your websites running on IIS?
How can I run an app at a specified time on the iPhone?
method-invoking Spring bean
What is the best way to specify execution time of recurring jobs or tasks?
powershell exchange : how do you setup a scheduled task to run exchange2007 powershell? (solved)
Working with the task scheduler 1.0 COM API
how to run a php file in schedule task
How do I stop/start a scheduled task on a remote computer programatically?
What is the best method for scheduled tasks in PHP
Is it possible to automate MS SQL Server (2005) queries via SQL Server Management Studio?
Graceful handling of dependent scheduled tasks?
Developing a scheduled task for Windows
GetProcessesByName() and Windows Server 2003 scheduled task
What is the Windows version of cron?
How do I set a task to run every so often?
How can I schedule a job in Sql Agent (Sql Server 2005) via C# code?
PHP: running scheduled jobs (cron jobs)
Scheduling Windows Mobile apps to run
"Out of Band" Processing Techiniques for asp.net applications
Windows 2003 Scheduled Task Cmdlet (v 1.0)
How do you schedule tasks in Windows?