Post reply

Process ID was killed by host process ID

  • August 28, 2012 at 8:29 am

    #145554

    We have one job that job was killed by hostname SVR1, host process ID 30416

    this job was configured same server SVR1

    the below information i have taken by sql server log

    "Process ID 62 was killed by hostname SVR1, host process ID 30416"

    HOw can i find out who has killed this job based on process id or anything else?

    is there any query?

  • August 28, 2012 at 9:45 am

    #1530910

    "host process ID 30416" refers to that user (or program's) Windows process ID. You'll need to check the windows Event Log (if you're lucky and its in there), or else monitor windows with Task Manager or Process Explorer or some other tool.

    [font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
    Proactive Performance Solutions, Inc.     [/font]    [font="Verdana"] "Performance is our middle name."[/font]

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

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