Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Andeh84
Starting Member
2 Posts |
 Posted - 2007-07-30 : 07:27:29
|
| Hi,I'm pretty new to SQL. I have wrote a simple update query and would like to know if there's anyway to get this to autorun rather than me running it manually every day. Frequency wise I would like it to update every day.Here is what I have so far, I would be grateful for any input you could give:update proceduresset procstatus = 'Finished'WHERE dateofprocedure = 'yesterday'and procstatus = 'Scheduled' |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-07-30 : 07:29:44
|
| just set up a scheduled job in sql server._______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenp |
 |
|
|
|
|
|
SQL auto update / run