How to Create a SQL Server Agent Job that Calls Another Job - SQL Server DBA Tutorial

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 power-shell 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"

Script to call SQL Server Agent Job inside another SQL Server Agent Job from Same Server or other instance.

--Call another job on same SQL Server
USE msdb 
EXEC dbo.sp_start_job N'BackupAlldb' 

--Call another job on different SQL Server 
-- Requires Linked server 
EXEC [TBSSQL\SQLPROD].[msdb].dbo.sp_start_job N'BackupAlldb'

How to Call SQL Server Agent Job/s from Another SQL Server Agent Job


  1. Replies
    1. I have read your article, it is very informative and helpful for me.I admire the valuable information you offer in your articles. Thanks for posting it.
      Tangki Panel
      Tangki Fiberglass
      Jual Septic Tank
      Mesin RO

      Tangki Fiberglass

  2. I am jovial you take pride in what you write. It makes you stand way out from many other writers that can not push high-quality content like you. tìm việc làm partime 365

  3. I need to to thank you for ones time for this particularly fantastic read!! I definitely really liked every part of it and i also have you saved to fav to look at new information in your site. digital literacy

  4. This is the last point of job application rejection, and it is a general issue throughout the current job-seeking world: personal confidence. Job seeking in itself is a job, and it is a tough one. Hr recruitment Companies in India

  5. Craigslist has built a reputation as a great resource of free and low-cost classifieds online, especially among company recruiters operating with limited budgets. But as the years pass, it's become clear that relying on Craigslist job posting