How to invoke a SQL job from another Job present on a different instance
For invoking an SQL Server Job from another Job which is present on a different instance, we have different
ways likesecurity reasons and creating
- Create a Linked server and use msdb..sp_start_job to
start the job - Using xp_cmdshell
- Using SQLCMD Operating system command