May 6, 2002 at 7:07 pm
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
Mike Weaver
May 6, 2002 at 10:10 pm
There is a knowledge base article for SQL Server 2000 about dtsrun.exe hanging.
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q290077
dtsrun.exe may be hanging in your case as well but may not be for the reasons outlined in that knowledge base article. If dtsrun.exe. is hanging (check task mananger to see if it is still running when it shouldn't be, or if you are remote, grab the pslist utility from SysInternals http://www.sysinternals.com to get a process list), you may want to use AutoDump+ to get some more information by forcing a user mode dump. Here's a knowledge base article about using AD+:
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q286350
K. Brian Kelley
http://www.sqlservercentral.com/columnists/bkelley/
K. Brian Kelley
@kbriankelley
May 7, 2002 at 5:25 am
Also check out http://support.microsoft.com/default.aspx?scid=kb;en-us;Q319698 which has a statement on SQL 7 that is fixed with SP4.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply