How to run a stored procedure every day in SQL Server Express Edition?
scheduled-tasks, sql, sql-server, sql-server-express
Solution
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
Problem
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