Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Full path for EXEC to execute a job
Message
From
15/01/2022 21:24:53
 
 
To
14/01/2022 22:22:43
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Miscellaneous
Thread ID:
01683201
Message ID:
01683270
Views:
39
>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.

Thanks

There is also the link server naming convention as well. I see a lot of syntaxes which do not refer to a server and its instance but rather the link server name.
Michel Fournier
Level Extreme Inc.
Designer, architect, owner of the Level Extreme Platform
Subscribe to the site at https://www.levelextreme.com/Home/DataEntry?Activator=55&NoStore=303
Subscription benefits https://www.levelextreme.com/Home/ViewPage?Activator=7&ID=52
Previous
Reply
Map
View

Click here to load this message in the networking platform