Best way to run date-triggered update? 1

[sarah2michelle]

We have an update statement that should run at 1201AM every day. What is the best way to do this?

I've found how to do it using a SQL Agent Job, but is that the best way? Does anyone know of other alternatives?

Thanks!
Sarah

 

[SQLDenis]

a scheduled Job is the best way to go

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[vongrunt]

> I've found how to do it using a SQL Agent Job, but is that the best way?

Arguably yes, because that way you have more control (although not perfect) over job, it's steps etc.

> Does anyone know of other alternatives?

Vanilla windows scheduler calling osql utility. I'd say this is like trading horse for a donkey in this case.

------
"There's a man... He's bald and wears a short-sleeved shirt, and somehow he's very important to me. I think his name is Homer."
(Jack O'Neill, Stargate)

 

[SQLSister]

That's how I would do it. Or you can create a DTS package and schedule it to run then, but it will still run as a job so you really don;t gain anything by doing that.

If you have SQLMAil set up on your system, have it email you everyday when it completes or fails so that you will check to make sure it is running properly.

Questions about posting. See faq183-874
Click here to help with Hurricane Relief

 

[sarah2michelle]

That brings up another problem then, but I'll post that to a new thread. Thanks again!