Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2002

    Unanswered: Maximum time to a job (SQL server agent).

    I have a job that run DTS package .
    In the Package it Execute some S.P from other servers and make other calculation .
    from time to time the job is stuck for hours .
    In this case the CPU goes up to 90 -100 % and the memory raise up too. ( I already have 2 processors and 2 GB memory )

    Do you know what is the way to stop the job automatically by SQL server agent after { 30 } minuets ( or ant other period of time ) .


  2. #2
    Join Date
    May 2008



    I have the exactly same need.
    I run a job that run an SSIS package that queries an external db.
    From time to time, that job never finishes.
    I then must stop it manually.
    I would like to put a timeout somewhere so that when the time has come the job step is marked as failed.

    How can I manage to do this ?

    a+, =)

Posting Permissions

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