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
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
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
ReplyDeletevidmate