Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Full path for EXEC to execute a job
Message
De
15/01/2022 21:24:53
 
 
À
14/01/2022 22:22:43
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Syntaxe SQL
Divers
Thread ID:
01683201
Message ID:
01683270
Vues:
41
>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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform