Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Full path for EXEC to execute a job
Message
From
14/01/2022 22:22:43
 
 
To
04/01/2022 15:32:55
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Miscellaneous
Thread ID:
01683201
Message ID:
01683267
Views:
41
>When EXEC executes a SQL Agent job with a syntax like this :
>
>
>EXEC [Something\Something].[msdb].[dbo].sp_start_job @job_name=N'Something'
>
>
>What would represent the first two place holders? Is it server name and instance?

That would be:
EXEC [ServerName\InstanceName].[msdb].[dbo].sp_start_job @job_name=N'Something'
I saw it several times when one server has installed more than 1 SQL Server. IOW, the instance name serves to identify each of them.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform