Executing a Stored Procedure at regular intervals using SQL Server Express Edition

SQL Server Express does not contain SQL Agent which can help us scheduling jobs. So to execute a stored procedure at regular intervals in SQL Express, we can use a Windows scheduler or Task Scheduler to execute a SQL Procedure using a SQLCMD.

I have covered Executing a Stored Procedure using SQLCMD, so I won’t be repeating the steps here. The only additional step is to create a batch file (Create a .txt and rename it to .bat) and add the commands to the batch file. Then use the Task Scheduler to execute this batch file at regular intervals

To see a practical example, like backing up a database at regular intervals using SQL Server Express , SQL Server MVP Jonathan Kehayias has covered these steps in an article over here called How to Automate Database Backups with SQL Server Express.

About The Author

Suprotim Agarwal, MCSD, MCAD, MCDBA, MCSE, is the founder of DotNetCurry, DNC Magazine for Developers, SQLServerCurry and DevCurry. He has also authored a couple of books 51 Recipes using jQuery with ASP.NET Controls and a new one recently at The Absolutely Awesome jQuery CookBook.

Suprotim has received the prestigous Microsoft MVP award for nine times in a row now. In a professional capacity, he is the CEO of A2Z Knowledge Visuals Pvt Ltd, a digital group that represents premium web sites and digital publications comprising of Professional web, windows, mobile and cloud developers, technical managers, and architects.

Get in touch with him on Twitter @suprotimagarwal, LinkedIn or befriend him on Facebook

No comments: