Automating and Scheduling the Transfer of Your Data
You can automate your data transfer using SQL Server Agent and SSIS. You can use Agent alone to schedule the various data movement techniques described above. SSIS can be used as well to graphically link various tasks and take advantage of the workflow engine that is built into it. In this section, we will walk through setting up a step for a backup procedure and then scheduling it.
Scheduling a Backup Operation Using SQL Server Agent
1. | In SQL Server Management Studio, open the SQL Server Agent node in Object Explorer and select the Jobs folder.
|
2. | Right-click the Jobs folder and select New Job from the context menu to open the New Job dialog box, shown below. This dialog box, like many SQL ... |
Get Microsoft® SQL Server™ 2005: Applied Techniques Step by Step now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
