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?
Is this a PowerShell background job or a SQL type job? If the former have you tried using Get-Job and looking at all the properties?
It is SQL Server job running a powershell step. I would assume it is already connected to sql server, just not sure how to extract the instance name it is executing against.
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.
To run a query you would need to provide the connection details, which change from environment to environment and which you are after.
Is there a way to tell powershell to use the local sql server on which the job is running?