|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
|
|
#1
May 25th, 2005, 10:02 PM
|
|||
|
|||
|
Dbms_job
hi,
I would like to submit a job that run a stored procedure, on every sunday 9am. Can give me the script to submit the job? I dont know how to write the script. THanks.
|
|
#2
May 26th, 2005, 02:49 AM
|
||||
|
||||
|
This article has it all.
__________________
My blog Tutorials about OSS databases, DBMonster ... Contribute to OSS Development, fill bug reports! Developer Shed eSupport Commented my.ini/my.cnf (ADD YOUR OWN CONFIG TRICK) An introduction to database normalization Natural or Surrogate key Custom ordering for your results Correlated and uncorrelated subqueries Don't turn your outer joins into inner joins Random data (with a bias)
|
|
#3
May 26th, 2005, 10:14 PM
|
|||
|
|||
|
|
#4
June 22nd, 2005, 03:08 AM
|
|||
|
|||
|
job first run
Hi,
I have read the articles, and have some test myself. However, i still cant figure out how to create a job so that the job can run in this Saturday (25-JUN-2005) 1:00 AM. Can someone pls help me? The below is the script i wrote: DECLARE jobno1 number; BEGIN DBMS_JOB.SUBMIT( job => jobno1, what => 'BEGIN HELLO_PROC; END;', next_date => TO_DATE('22-JUN-2005 01:00:00','DD-MON-YYYY HH24:MI:SS'), interval => 'SYSDATE +16/24' ); COMMIT; END; When i run this script, the 'hello' stored procedure have been executed. How to make the first run on saturday 1:00AM? Thanks!
|
|
#5
June 22nd, 2005, 03:22 AM
|
|||
|
|||
|
job first run
Hi,
I have read the articles, and have some test myself. However, i still cant figure out how to create a job so that the job can run in this Saturday (25-JUN-2005) 1:00 AM. Can someone pls help me? The below is the script i wrote: DECLARE jobno1 number; BEGIN DBMS_JOB.SUBMIT( job => jobno1, what => 'BEGIN HELLO_PROC; END;', next_date => TO_DATE('22-JUN-2005 01:00:00','DD-MON-YYYY HH24:MI:SS'), interval => 'SYSDATE +16/24' ); COMMIT; END; When i run this script, the 'hello' stored procedure have been executed. How to make the first run on saturday 1:00AM? Thanks!
|
|
| Viewing: Dev Shed Forums > Databases > Oracle Development > Dbms_job |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
