DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 12 of 12

Thread: dbms_job.interval

  1. 03-30-2001, 05:57 PM #11
    Chintz
    Chintz is offline Member
    Join Date
    Dec 1999
    Posts
    217
    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
    Reply With Quote Reply With Quote
  2. 03-30-2001, 05:59 PM #12
    Queyon
    Queyon is offline Member
    Join Date
    Mar 2001
    Posts
    133

    Wink DBMS_JOBS


    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.
    Queyon Zeng
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

Click Here to Expand Forum to Full Width