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?
A:
Create a job with monthly schedule in Sql Agent and assign a T-Sql task to it with this query.
Denis Valeev
2010-09-24 15:34:55
I don't seem to see a SQL Agent. Sorry I failed to mention this was Sql Server 2005 Express and I'm using Management Studio Express. Can I still accomplish this? Thanks!
drpcken
2010-09-24 16:02:45
This would be a good option if there was another non-Express SKU of SQL Server running elsewhere.
p.campbell
2010-09-24 16:32:58
down voted because they didn't look up that express doesn't come with sql server agent.
DForck42
2010-09-24 19:56:24
+4
A:
For SQL Server Express, there are a few possibilities. Unfortunately none of them involve Management Studio:
- Use a combination of Windows Scheduler, sqlcmd.exe, and .bat files
- Use SQL Server Service Broker
- Use a Codeplex variation of SQL Agent
- Use SQL Scheduler (free download)
8kb
2010-09-24 16:22:45