O'Reilly logo

SQL Server 2017 Integration Services Cookbook by Dejan Sarka, Matija Lah, Christian Cote

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

How to do it...

  1. In SSMS, in the Object Explorer, locate the SQL Server Agent node. Expand it to show its contents, and locate the Jobs folder.
If the SQL Server Agent of the selected SQL Server instance is not running, right-click its node in the Object Explorer, and select Start from the shortcut menu to start it.

 

  1. Right-click the Jobs folder in the Object Explorer, and select the New Job... command from the shortcut menu to open the New Job wizard, as shown in the following screenshot:
  2. On the General page of the New Job wizard, enter Chapter06Scheduled as the Name of the job, as shown here:
  3. On the Steps page, click New... to add a ...

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