Oracle job scheduling?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: Oracle job scheduling?

  1. #1
    Join Date
    Aug 2000
    Posts
    68

    Thumbs down

    Hello All

    This is just a quick one for you?
    the NEXT_SEC parameter below, is the next time a job is scheduled to run? Right?

    I think that the value that i originally set has changed?

    By this i mean i set it for 7.30 & now its showing up as 2.30?

    Any ideas?

    Could this be possible?

    Again many thanks for any help recieved


    SELECT WHAT, JOB, LAST_DATE, NEXT_DATE, NEXT_SEC, BROKEN FROM USER_JOBS
    Carpe Diem

  2. #2
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    You have submited your job with inapropriate job interval setting - you are experiencing "NEXT_DATE drifting". See
    http://www.dbasupport.com/forums/sho...threadid=11185
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  3. #3
    Join Date
    Dec 2001
    Location
    SAN FRANCISCO, CA
    Posts
    306
    hi Jurij

    http://www.dbasupport.com/forums/sho...threadid=11185

    This was a very good informative link . U have explained it in a very good and simple way . I had my doubts cleared .

    Great !!!

    Regards
    Pravin




  4. #4
    Join Date
    Aug 2000
    Posts
    68
    Hi Jurij

    Thanks for the really informative link, i realize that a few weeks back the DB was unavailable till around 2 and that meant no updates until that time. So thanks Again for your help with this.

    I have 4 jobs to re-submit, am i right in saying i have to delete them from DBMS job queue first before i re-submit?
    & if this is the case. I wonder would you know the exact syntax for the deletion of the affected jobs?

    Again Many thanks for your help so far, Your knowledge is most impressive.
    Carpe Diem

  5. #5
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    You don't have to remove those 4 jobs if all you want to do is to resubmit them. You can use various DBMS_JOB procedures to change various parameters of your job, for example:

    - DBMS_JOB.INTERVAL for changing the job's interval setting
    - DBMS_JOB.NEXT_DATE for changing the time of job's next execution
    - DBMS_JOB.WHAT for changing the contents of your job
    - DBMS_JOB.CHANGE for changing all of the above options in one step

    If you are uncomfortable with the above procedures then you can remove all your jobs using DBMS_JOB.REMOVE and then resubmit them with DBMS_JOB.SUBMIT or DBMS_JOB.ISUBMIT.
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  6. #6
    Join Date
    Aug 2000
    Posts
    68
    hi Jurij

    Thank you kindly for all your help.
    I deleted the jobs & re-submitted them.

    Everything should be ok for tomorrow

    Regards & Many Thanks
    Carpe Diem

Posting Permissions

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



Click Here to Expand Forum to Full Width