Getting Return Values for Exec statments

• Namshub

  SSC Journeyman

  Points: 79

  More actions

  August 6, 2003 at 2:58 am

  #82502

  Hi

  I am using the sp;

  msdb.dbo.sp_Start_job @Job_Name = 'Cancer Dataset CSV Output'

  What i want to know is how do i find the return value. Reading the Help it is either 0 or 1 but how do i get this value?

  i have tried using an if statement before the exec then = 1, but it does not work.

  Cheers

• mccork

  SSC-Insane

  Points: 22288

  More actions

  August 6, 2003 at 3:21 am

  #468764

  Try:

   
  
  declare @retcode int
  
  exec @retcode = msdb.dbo.sp_Start_job @Job_Name = 'Cancer Dataset CSV Output'
  
  select @retcode

  Cheers,

  - Mark

  
  Cheers,
  - Mark