Post reply

SQL Agent Job Who ran ?

  • December 17, 2015 at 7:51 am

    #323396

    Hello,

    We have a sql agent job that runs a ssis package using a proxy account.

    This job is not scheduled and run manually by going to SQL Agent Jobs >> Rt.Click Job >> Start Job at step.

    Is there any way to capture who ran the job. I have logging in ssis package via system variables but it captures only proxy account info but not the user account that ran the job.

    Any help greatly appreciated.

  • December 18, 2015 at 2:24 am

    #1846714

    Check the job history in Job Activity Monitor or MSDB, it should detail who started the job.

  • December 18, 2015 at 11:21 am

    #1846851

    You are correct.

    I see on the first or 0 step it actually shows the user who invoked the job and if you drill down the history by clicking + you will see proxy account info.

    Now, I will try to parse the Message to only pull the domain\username from that message.

    Appreciate your help.

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

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