Post reply

Agent job having step type powershell-How to find spid?

  • July 3, 2017 at 4:35 am

    #331664

    Good morning Experts,

    We have a Agent job. It has a step of type powershell. The job is running from long time. I want to know the SPID of the job but am unable to find it. I am getting the job_id but i want to know the spid. Please help

  • July 3, 2017 at 8:08 am

    #1949149

    The SPID would relate to the connection to SQL Server. A PoSh step doesn't necessarily make a connection to SQL Server. If this is running a long time, could it be stuck waiting for user input?

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

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