Home » SQL & PL/SQL » SQL & PL/SQL » HOW TO SCHEDULE A TASK IN ORACLE
HOW TO SCHEDULE A TASK IN ORACLE [message #206561] Thu, 30 November 2006 09:35 Go to next message
ramsatish
Messages: 8
Registered: November 2006
Junior Member
Hi,
I have a Stored Procedure which should be execute every sunday.
Instead of executing manually,I want stored procedure executed
automatically every sunday.

I am using oracle8i.How can i do this task.

Thanks in advance

Thanks and Regards,
Sriram Satish Boddu
Re: HOW TO SCHEDULE A TASK IN ORACLE [message #206563 is a reply to message #206561] Thu, 30 November 2006 09:37 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
DBMS_JOB
Re: HOW TO SCHEDULE A TASK IN ORACLE [message #206564 is a reply to message #206561] Thu, 30 November 2006 09:37 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Search forum/documentation/google for
DBMS_JOB (to schedule from oracle).
To schedule from OS , look into crontab(unix) and scheduler (windows)
Re: HOW TO SCHEDULE A TASK IN ORACLE [message #206719 is a reply to message #206564] Fri, 01 December 2006 04:07 Go to previous messageGo to next message
ramsatish
Messages: 8
Registered: November 2006
Junior Member
Mahesh Rajendran wrote on Thu, 30 November 2006 09:37
Search forum/documentation/google for
DBMS_JOB (to schedule from oracle).
To schedule from OS , look into crontab(unix) and scheduler (windows)

Re: HOW TO SCHEDULE A TASK IN ORACLE [message #206720 is a reply to message #206719] Fri, 01 December 2006 04:09 Go to previous message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
@Ramsatish - This is a serious question. Why did you just copy and paste the previous post?
Previous Topic: how to avoid query output when called from shell script
Next Topic: Time to export data to a CSV-file
Goto Forum:
  


Current Time: Mon Dec 05 13:01:44 CST 2016

Total time taken to generate the page: 0.11259 seconds