Thanks. I will leave it as it is right now. ANd will check if it ran and if I have any issues I'll probably pull this thread out and update it.
Thanks for all your input.
Chintz
Printable View
Thanks. I will leave it as it is right now. ANd will check if it ran and if I have any issues I'll probably pull this thread out and update it.
Thanks for all your input.
Chintz
The syntax is correct and your expression of the interval is also correct. But the interval value will not change unless you run the job. Once you run the job by 'DBMS_JOB.RUN(123);' you'll see the next_sec has been changed.