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

Question

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:

• How can I schedule a daily backup with SQl Server Express?
• Scheduled run of stored procedure on SQL Server

Answer 1

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