Post reply

Is there a timeout on jobs?

  • July 4, 2003 at 3:40 am

    #80515

    Hello

    I need to run a stored procedure for more than 12 hours (it will take that long) and I'm not sure if a job can timeout since I can't see a timeout box when setting up a job. Is there a maximum limit or can it process data in a single call of a stored procedure for a half day or more?

    Thank you in advance 😉

    Johan Nikkanen

  • July 4, 2003 at 10:35 pm

    #464211

    Should not be a problem. I've often run procedures that run continuously (eg. procedures that check for blocking and take appropriate action). Such procedures have usually included a WAITFOR delay within their logic so that they're not hammering CPU.

    In your case you'll probably have the proc running continuously without any waits, but you should have no problems as long as you do not have any query governor setting in effect (the default is NO query governor settings).


    Cheers,
    - Mark

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply