error executing msdb.dbo.sp_help_job

• tzones2006

  SSC Enthusiast

  Points: 170

  More actions

  August 10, 2010 at 1:01 pm

  #142347

  Hi,

  I am trying to execute the stored procedure [msdb].[dbo].sp_help_job to know the DTS jobs that are currently running. I am using SSMS 2005 to connect to SQL Server 2000 and I am logged in as a normal user.

  Here's the error I am getting when executed:

  A severe error occurred on the current command. The results, if any, should be discarded.

  Also I have granted executable permissions to my login on that stored procedure but still get the same error.

  Can anyone suggest me what am I doing wrong? Is this something to do with the user roles?

  thanks

  TZ

• Bill Galashan

  SSChasing Mays

  Points: 623

  More actions

  August 10, 2010 at 1:07 pm

  #1204996

  is this KB relevant http://support.microsoft.com/kb/910416

  you may also see Exception 0xc0000005 EXCEPTION_ACCESS_VIOLATION reading address 00000020 at 0x0110B72B 2. int the error log

  if so this is a known bug and there is a hotfix

• tzones2006

  SSC Enthusiast

  Points: 170

  More actions

  August 10, 2010 at 1:17 pm

  #1205000

  Hi,

  Thanks for your reply. I am getting the same error when connected to the SQL Server 2000 from SSMS 2008. Guess this is something to do with the server I am connecting to and not the client itself.

  thanks

  TZ