I have a SQL Server Agent job that calls a PowerShell script in one step. And I want to pass the SQL server name and the current job-id to my script.
With the job-id I have no problems. But with the server name...
My PowerShell call looks like this:
.\StopServices.ps1 -ServerName $(ESCAPE_DQUOTE(A-SVR)) -JobId $(ESCAPE_DQUOTE(JOBID))
The job-id works perfect, but the server name is empty.
How can I pass the server name to my PowerShell script?