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
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?