sql server agent

• shriya

  SSC Journeyman

  Points: 94

  More actions

  July 16, 2011 at 10:06 am

  #240940

  I have sql server 2005 sql server agent is running

  my job which cmdexec is not run and i get error SSIS subsystem failed

  I saw my entry in msdb is

  select * from syssubsystem

  3CmdExec14550C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\binn\SQLCMDSS90.DLLNULLCmdExecStartCmdEventCmdExecStop20

  The agent_exe field is null

  Is this the reason for cmdexec to fail

  What should be the entry

  thanks

  Shriya

• Welsh Corgi

  SSC Guru

  Points: 116520

  More actions

  July 17, 2011 at 10:36 am

  #1353963

  What error are you getting?

  Can you execute it interactively?

  For better, quicker answers on T-SQL questions, click on the following...
  http://www.sqlservercentral.com/articles/Best+Practices/61537/

  For better answers on performance questions, click on the following...
  http://www.sqlservercentral.com/articles/SQLServerCentral/66909/