Log return value from exec sp in job agent (step) history?

• rotcha99

  Mr or Mrs. 500

  Points: 594

  More actions

  October 12, 2018 at 2:39 am

  #381004

  Hi,
  I wonder if there's a quick way to have the return value from an EXEC stored-procedure Statement logged automatically in the Job steps history table...

  just before I construct my very own Tools 😉

  Thanks,
  Roer

• John Mitchell-245523

  SSC Guru

  Points: 148809

  More actions

  October 12, 2018 at 2:45 am

  #2009298

  DECLARE @Return int;
EXEC @Return = MyProc;
SELECT @Return; -- or try PRINT or RAISERROR

  John

• rotcha99

  Mr or Mrs. 500

  Points: 594

  More actions

  October 12, 2018 at 3:24 am

  #2009302

  I see, raising an exception could do the trick and produce an entry in the log...

• Phil Parkin

  SSC Guru

  Points: 247180

  More actions

  October 12, 2018 at 4:58 am

  #2009334

  --Deleted

  ---