Wednesday, March 21, 2012

how to use server time as an event

Hi, I want to do some data transfer from a network share and also run
some stored procedures.
How can I get them to run at a designated time, automatically?Hi

There are numerous ways to do this! You can use the SQL Server scheduler to
run a DTS package or other tasks, but the Windows Scheduler may also be
used.

Details on DTS can be found in Books online and there is a great resouce at
http://www.sqldts.com

John

"Hitcher" <steveChambers66@.hotmail.com> wrote in message
news:2f89f21f.0310220828.7ae813f9@.posting.google.c om...
> Hi, I want to do some data transfer from a network share and also run
> some stored procedures.
> How can I get them to run at a designated time, automatically?

No comments:

Post a Comment