Home » SQL & PL/SQL » SQL & PL/SQL » Job Scheduling (10g)
Job Scheduling [message #349204] Fri, 19 September 2008 05:46 Go to next message
me_maddy
Messages: 31
Registered: April 2008
Member
I have created a procedure test,How can I schedule it at oracle level to get executed for every 1 hr.

Appreciate your inputs!!
Re: Job Scheduling [message #349208 is a reply to message #349204] Fri, 19 September 2008 06:03 Go to previous messageGo to next message
Michel Cadot
Messages: 64117
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Use dbms_job.

Regards
Michel
Re: Job Scheduling [message #349211 is a reply to message #349204] Fri, 19 September 2008 06:05 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
DBMS_JOB / DBMS_SCHEDULER

{drat - too slow}

[Updated on: Fri, 19 September 2008 06:06]

Report message to a moderator

Re: Job Scheduling [message #349214 is a reply to message #349204] Fri, 19 September 2008 06:08 Go to previous message
joicejohn
Messages: 327
Registered: March 2008
Location: India
Senior Member
@me_maddy,

You can use DBMS_JOB for scheduling.

These links might help:

1/ http://www.oradev.com/dbms_scheduler.jsp
2/ http://download-uk.oracle.com/docs/cd/B28359_01/server.111/b28310/appendix_a004.htm
3/ http://www.orafaq.com/node/871 (For pre-10g releases)

Regards,
Jo

[Updated on: Fri, 19 September 2008 06:08]

Report message to a moderator

Previous Topic: Help requried in Writing query with Analytical function
Next Topic: Regarding Batch Job to retrieve data from Client DB to our local DB
Goto Forum:
  


Current Time: Tue Dec 06 04:43:06 CST 2016

Total time taken to generate the page: 0.06220 seconds