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

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.

Script used in video to Run SQL Server Agent Job from Batch File

sqlcmd -S TBSSQL\SQLPROD -E -d MSDB -Q "sp_start_job 'Test'"



How to Execute SQL Server Agent Job/s From Batch File - SQL Server DBA Tutorial

1 comment:

  1. ring the article, and more importantly, your personal experience mindfully using our emotions as data about our inner state and knowing when it’s better to de-escalate by taking a time out are great tools. Appreciate you reading and sharing your story since I can certainly relate and I think others can too
    vidmate

    ReplyDelete