'The TSQL subsystem failed to load'

[isond]

Hi,

I get the error 'The TSQL subsystem failed to load' when running a scheduled SQL Task, the actual step that fails seems to vary. Once this error occurs the job becomes suspended and I have to restart SQL Agent in order to be able to attempt to re-run the job. The job then re-runs fine with no errors.

I have looked on various web sites including Microsofts and can't find any reference to this problem.

I am using SQL Server ODBC driver version 3.81

Any help would be greatly appriciated.

Thanks,

Darren Ison.

 

[JayKusch]

Do other jobs cause this issue?

Thanks

J. Kusch

 

[isond]

J. Kusch,

No but I added extra steps to the same job and the issue occurred on these steps as well.

The step that first caused the issue was to kill all users from a database. The extra steps I put in were to stop and start a service that we thought might be causing a problem. Since adding these steps the problem has occurred on both the stop service step and the start service step.

Thanks,

Darren.

 

[JayKusch]

What Service are you trying to stop/restart. Hopefully not the SQL Server Agent Service - LOL.

Thanks

J. Kusch

 

[MDXer]

From MS Knowledgebase

PRB: SQL Server Agent Job Fails with Error Message "...Driver's SQLSetConnectAttr failed..."
View products that this article applies to.
This article was previously published under Q315005
SYMPTOMS
A SQL Server Agent job may fail with the following message in the job history:

Unable to start execution of step 1 (reason: The ?? subsystem failed to load [see the SQLAGENT.OUT file for details]; The job has been suspended). The step failed.
If the preceding error message occurs, look in the Sqlagent.out file for this error message:

Have you looked for the SQLAGENT.OUT file? if so what does it state.

"Shoot Me! Shoot Me NOW!!!"
- Daffy Duck

 

[isond]

Guys,

Below is a more detailed description of what we are doing.

The job has 12 steps and runs at midnight, the step that fails is step 1 which is below.

exec usp_KillUsers 'Postilion'

However during investigating the problem I added the following step as step 1

xp_cmdshell 'net stop "Postilion Office Sentinel"'

This then failed with the same error.

I also added the following step as the last step

xp_cmdshell 'net start "Postilion Office Sentinel"'

Now sometimes the job fails on step 1 and sometimes on the last step.

The only other job that appears to sometimes have this problem is a backup job that runs at 10 AM. I think this might fail if SQL agent is not restarted before the job trys to run.


Comment from acperkins
Date: 04/19/2004 05:31PM BST
Comment


Click "Show step details" and post here the real error or take a look at your SQL Server logs.

Comment from arbert
Date: 04/19/2004 05:39PM BST
Comment


What version/SP of sql server (select @@version)?

Comment from isond
Date: 04/19/2004 05:45PM BST
Your Comment


Here is exactly what the step says.

Unable to start execution of step 15 (reason: The TSQL subsystem failed to load [see the SQLAGENT.OUT file for details]; The job has been suspended). The step failed.

The SQLAgent log has the following entries, the logging level is set to 7

2004-04-17 01:27:26 - ! [LOG] Step 15 of job 'TNS: Offline Database Population' (0xD9CA60855FBB054CA8BE11632F2810D4) cannot be run because the TSQL subsystem failed to load. The job has been suspended
2004-04-17 01:27:26 - ? [182] Job completion for TNS: Offline Database Population is being logged to the eventlog
2004-04-17 01:27:26 - ? [247] Job completion for TNS: Offline Database Population is being sent to operator 'datacentre' via network popup
2004-04-17 01:27:26 - ? [183] Job completion for TNS: Offline Database Population is being emailed to operator 'datacentre'
2004-04-17 01:27:26 - ? [184] Job completion for TNS: Offline Database Population is being logged to sysjobhistory

The Version of SQL is

Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05 Copyright (c) 1988-2003 Microsoft Corporation Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 4)