We have multiple environments with different instance names. Currently I use this command to define the connection to the instace:
So the instance name is hard coded.
I am running the script as a job step and need this job to work in all environments without updating the job code.
How do I find out the server and the instance name with powershell on which the SQL job is running?
I'm not sure how you could look inside SQL unless you could run a SQL query against the computer using Invoke-SQLCmd to get running jobs and look at them.
Powered by IDERA