sql server - automate a SQL query to run every month

Question

I have a simple SQL query that updates some date fields in a record, on a SQL Express instance.

I'd like to have it run automatically every month. What is the best way of accomplishing this in SQL Server 2005 Express using the Management Studio?

Answer 1

For SQL Server Express, there are a few possibilities. Unfortunately none of them involve Management Studio:

1. Use a combination of Windows Scheduler, sqlcmd.exe, and .bat files
2. Use SQL Server Service Broker
3. Use a Codeplex variation of SQL Agent
4. Use SQL Scheduler (free download)