| Daily Run Job Question [message #8269] |
Wed, 06 August 2003 21:03  |
Joe
Messages: 138
Registered: November 1999
|
Senior Member |
|
|
I currently have a job running like so:
dbms_job.submit(:v_job,
'resetincident;',
trunc(add_months(sysdate, 12), 'y'),
'trunc(add_months(sysdate, 12), ''y'')');
I am looking at how I would change it so that instead of running once a year, it will run at midnight, every single night. Can anyone help?
Thanks!
|
|
|
|
| Re: Daily Run Job Question [message #8272 is a reply to message #8269] |
Wed, 06 August 2003 21:24  |
 |
Barbara Boehmer
Messages: 9090
Registered: November 2002
Location: California, USA
|
Senior Member |
|
|
The following would schedule the job to start at the next midnight and execute each midnight thereafter:
dbms_job.submit(:v_job,
'resetincident;',
trunc (sysdate) + 1,
'trunc (sysdate) + 1');
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
