SQL JOBS STUCK IN EXEC

• mhweaver

  SSC Rookie

  Points: 48

  More actions

  May 6, 2002 at 7:06 pm

  #157713

  Anyone,

  I am running SQL7 with SP3. My scheduled jobs are not completing normally.

  The job completes all steps but in the managment window the jobs still show as

  running. The problem seems to only revolve around jobs that have the data transform task. Simple t-sql jobs complete normally.

  Running out of threads and nerves...........

  Thanks for any ideas.

  Mike Weaver

  
  Mike Weaver

• K. Brian Kelley

  SSC Guru

  Points: 114642

  More actions

  May 6, 2002 at 10:34 pm

  #428568

  Please don't cross post. Most of us surfing the forums read all the topics. Check my reply at:

  http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=4066&FORUM_ID=9&CAT_ID=1&Topic_Title=SQL+JOBS+STUCK+IN+EXEC&Forum_Title=General

  K. Brian Kelley

  bkelley@sqlservercentral.com

  http://www.sqlservercentral.com/columnists/bkelley/

  K. Brian Kelley
  @kbriankelley