In this video you will learn step by step process of creating SQL Server agent job that calls another job on same SQL Server instance or remote SQL Server using T-SQL Script. It also explains what is required to connect to remote SQL Server in this scenario (Creating Linked Server) or using powershell script to connect to remote SQL Server. It also provides a resolution to an error " The server doesn't allow RPC connection or RPC is disabled on the server"
Blog post link for the video with scripts
http://sqlage.blogspot.com/2015/03/ho...
Visit our website to check out SQL Server DBA Tutorial Step by Step
http://www.techbrothersit.com/2014/12...
On this page of the site you can watch the video online SQL Server DBA Tutorial 122-How to Create a SQL Server Agent Job that Calls Another Job with a duration of online in good quality, which was uploaded by the user TechBrothersIT 29 March 2015, share the link with friends and acquaintances, this video has already been watched 8,164 times on youtube and it was liked by 25 viewers. Enjoy your viewing!