O'Reilly logo

Smart Business Intelligence Solutions with Microsoft® SQL Server® 2008 by Kevin S. Goff Lynn Langit Davide Mauri, Sahil Malik, and John C. Welch

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

SQL Server Agent and Integration Services

After your SSIS packages have been deployed to the target server or servers, you need to schedule their execution. To do that, you’ll generally use SQL Server Agent by creating a specific job for the execution of each (normally updated) package.

To create a new job, just expand the SQL Server Agent menu item from the SSMS so that you can see the item Jobs. Right-click Jobs and select the New Job option from the shortcut menu. You need to provide a name for the job.

A job is made of smaller elements called steps, which can perform specific actions. To create a new step, select the Steps page on the left side of the dialog box, and click the New button at the bottom of the dialog box. A name for the job step ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required