| Modify job [message #57718] |
Wed, 02 July 2003 01:47  |
Dik
Messages: 27
Registered: June 2002
|
Junior Member |
|
|
Hi,
How can I change interval to existing job?
Thanks
|
|
|
|
| Re: Modify job [message #57724 is a reply to message #57718] |
Wed, 02 July 2003 09:57  |
Joe
Messages: 138
Registered: November 1999
|
Senior Member |
|
|
Dik,
To modify the next_date for an already scheduled job:
assuming the job looks like this:
exec dbms_job.change(
job IN BINARY_INTEGER, what IN VARCHAR2, next_date IN DATE,
interval IN VARCHAR2,
instance IN BINARY_INTEGER DEFAULT NULL,
force IN BOOLEAN DEFAULT FALSE);
for example, if you have job# 16, that runs 'some_proc', and you want it to run once a day instead of twice a day:
exec dbms_job.change(16,'some_proc;',sysdate,'sysdate+1);
Hope that helps
joe
|
|
|
|
| Re: Modify job [message #57745 is a reply to message #57724] |
Thu, 03 July 2003 02:11 |
Dik
Messages: 27
Registered: June 2002
|
Junior Member |
|
|
Hi,
When I start 'exec dbms_job.change(16,null,null,sysdate+1) i get error ORA-23421: job number 16 is not a job in the job queue, but in 'select * from dba_jobs' I can see job #16!
What is difference between 'exec dbms_job.change...' and exec dbms_job.interval?
Thanks
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
