SQL agent job hung up

• sarita Garg

  SSC Eights!

  Points: 824

  More actions

  September 22, 2004 at 8:28 am

  #112441

  I have a batch file which has an executable in it written in C.  I have scheduled it to run once daily in the morning.  Once in a while this job hangs up.  I found that this executable file is there in the task manager and until I remove it from there job will not run and complete successfully.  Why would the OS hold the connection and how we can resolve this problem?  I have seen the same problem with another application also.

  Any help will be greatly appreciated.

  Thank you

• Peter Tillotson

  Hall of Fame

  Points: 3325

  More actions

  September 23, 2004 at 6:51 am

  #524147

  Have you checked in enterprise manager that there aren't any locks in the database holding up your job?

  Does your application specifically CLOSE the connection to the database?

  Peter