Results 1 to 12 of 12
  1. #1
    Join Date
    Jan 2004
    Location
    Montreal, Canada
    Posts
    151

    Unanswered: Sql Job problem!!!

    Here is the problem...I have a job that re executes all the time its scheduled to run every 10 min but it re executes all the time it does not wait 10 min they only way i can get it to stop is if i disable the actual job . so the question is Y does this job not stop and wait 10 min hat can make it re executed like that ?.

  2. #2
    Join Date
    Jan 2004
    Location
    Boston
    Posts
    58
    check these:
    1. what's the job doing, any coding that does WHILE loop?
    2. Does the job have two separate schedules?
    3. Does the job get called by other jobs?

  3. #3
    Join Date
    Jan 2004
    Location
    Montreal, Canada
    Posts
    151
    no it does not get called by other job and does not containe any other schedules theres a while but that is working perfectly fine in the status i have notice that it say executing than it stops and strats right back up again

  4. #4
    Join Date
    Jan 2004
    Location
    Boston
    Posts
    58
    What does the job history say? what if you disable the job and run it once? does it go into a loop?

  5. #5
    Join Date
    Jan 2004
    Location
    Montreal, Canada
    Posts
    151
    the job was invoked and ran succesfully and the when i disable the job it stops does not go into any loop.

  6. #6
    Join Date
    Jan 2004
    Location
    Boston
    Posts
    58
    so when you re-enabled it, does it automatically run on schedule but never ends, or do you have to start it manually? do a DBCC INPUTBUFFER (spid) to see what's running under the job. Can you post the job command?

  7. #7
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    If you schedule SQL Agent to "every 10 minutes" that means that the job will start at 6:00, 6:10, 6:20, etc... Did you want to have the job start back up 10 minutes after the first run finishes? for a job that runs in 5 minutes every time this would look something like:
    6:00, 6:15, 6:30...

  8. #8
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Originally posted by MCrowley
    If you schedule SQL Agent to "every 10 minutes" that means that the job will start at 6:00, 6:10, 6:20, etc... Did you want to have the job start back up 10 minutes after the first run finishes? for a job that runs in 15 minutes every time this would look something like:
    6:00, 6:15, 6:30...

    uhhhh... you forgot a 1....
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  9. #9
    Join Date
    Jan 2004
    Location
    Boston
    Posts
    58
    Nop. The schedule doesn't care how long the job actually takes to finish. It just occurred to me that is this the reason the job seems running forever - it simply takes, say 9.9 minutes to run and continue on next schedule?

  10. #10
    Join Date
    Jan 2004
    Location
    Montreal, Canada
    Posts
    151
    well seems to be a bug in sql since i copied the job and its exact content and everything is working fine

  11. #11
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    Brett: I oughta take an english class some day ;-) I meant a job that runs for 5 minutes, then waits 10, rns for 5, waits ten, etc... Sorry about that confusion.

  12. #12
    Join Date
    Mar 2004
    Location
    Canada
    Posts
    1

    Hi

    I am looking for a position as software developer. (SQL, Delphi..OO)
    I am living in Toronto.
    Is anybody who knows about it in Canada?
    Thank you
    Daniel

Posting Permissions

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