How to run a stored procedure every day in SQL Server Express Edition?

Asked 2009-11-04T17:00:50.613

25

How is it possible to run a stored procedure at a particular time every day in SQL Server Express Edition?

Notes:

This is needed to truncate an audit table
An alternative would be to modify the insert query but this is probably less efficient
SQL Server Express Edition does not have the SQL Server Agent

Related Questions:

sql sql-server sql-server-express scheduled-tasks

Edit Report

1 Answer

25

Since SQL Server express does not come with SQL Agent, you can use the Windows scheduler to run a SQLCMD with a stored proc or a SQL script.

http://msdn.microsoft.com/en-us/library/ms162773.aspx

answered 2009-11-04T17:03:36.623

Your Answer