Hey

I want to learn more on how to schedule tasks in Sql Server 2005.

Lets say I have a table containing some records. At a certain time I want
this records to be copied over to another table. The time when this data
trasfer should execute is stored in another table in the same database.

So I'm looking for links to documentation on how to do this in Sql Server
2005

Any suggestions?

Jeff

Jeff (it_consultant1@hotmail.com.NOSPAM) writes:
[quoted text, click to view]

One possibility is to have a job in SQL Server Agent which periodically
polls the table, and if the time is due copies the table.

Rather than storing the time in the table, the application could just
schedule a job to run the copying when needed.

I would not be surprised if Service Broker is good for this kind of thing.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at