Schedule SQL based Services

To perform some Schedule based database activity you can use SQL Server Integration Services. Which comes with VS 2005 and SQL Server 2005.

It provides several tasks by which it enable to schedule any jobs based on SQL ,File System, Process,FTP etc.

One can also use Script Task to make dynamic Scheduling Using SSIS.

Some common task which i have been already implemented are
1. Script Task
2. File System Task
3. FTP Task
4. Send Mail Task
5. Transfer Database Task
6. Execute SQL Task
7. Backup Database Task
8. Transfer jobs Task
9. Web Service Task
10.Activex Script task
11.Bulk Insert Task
12.For Each Loop Container Task
13.For Loop Container Task

One can use www.sqlauthority.com to learn many more task list of SSIS.
Once these task is prepared as per requirement we can schedule it on database server easily.