From the course: Implementing a Data Warehouse with Microsoft SQL Server 2012

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Using SQL Server Agent to execute an ETL package

Using SQL Server Agent to execute an ETL package - SQL Server Tutorial

From the course: Implementing a Data Warehouse with Microsoft SQL Server 2012

Start my 1-month free trial

Using SQL Server Agent to execute an ETL package

“

In this section, I'd like to talk about using the SQL server agent to execute an ATL package on a regular basis. Here in Microsoft SQL Server Management Studio, I am going to go to the bottom item on the treeview the sequel server agent. And I'll see that in the sub-items the top choice is jobs. I'll right click on jobs, and say new job. So a job is a unit of work, in the SQL server agent. It's something that's going to executed as a whole connected to a schedule. Actually connected to one, or more schedules. Typically we just have one schedule for a job But you can have more than one. On this first screen I just need to provide a name for the job, I'll call it Demo. The next item is Steps, so I'll need to add the steps of the job one at a time. In the lower left, we see the option for a new step I have the choice of different types of steps. I'm going to go with SQL server integration services package and the bottom half of the interface changes to something that asks me what package…

Contents