SQL Server DBA Tutorial 121-How to Run SQL Server Agent Jobs in Batch File

In this video you will learn how to run SQL Server Agent Job in a Batch file, it explains step by step process of creating a batch file using SQLCMD, connecting with target SQL Server, database and running SQL Server Store procedure from a batch file. It also shows step by step process of creating and scheduling batch job in windows scheduler instead of using SQL Server Agent Scheduler.

Blog post link with script used in this video

Visit our website to check out SQL Server DBA Tutorial Step by Step