Post reply

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

  • 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

  • October 12, 2018 at 2:45 am

    #2009298

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

    John

  • October 12, 2018 at 3:24 am

    #2009302

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

  • October 12, 2018 at 4:58 am

    #2009334

    --Deleted

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply