From the course: SQL Server Integration Services
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Schedule packages with SQL Server Agent - SQL Server Tutorial
From the course: SQL Server Integration Services
Schedule packages with SQL Server Agent
- [Instructor] Executing SSIS packages manually will force them to run immediately. But the entire point of developing an automated workflow is so that you don't need to manage it. Many if not most SSIS packages are scheduled to run during off-peak hours. For instance, you might want a lengthy ETL process or backups to occur at night or on the weekend when those activities won't impact business transactions. And you don't want to be the one that has to be standing by in the wee hours of the morning to hit the execute button. So instead we'll use the SQL Server Agent to schedule the execution of our Integration Services package. To start the agent needs to be running. Mine currently isn't. And you can tell that by the red X icon overlay here, next to SQL Server Agent. So I'm going to right-click on it and choose Start. That'll prompt me a couple of times and I'll just say Yes to both of these dialog boxes and then I'll start up the agent service. Once you see the green arrow overlay…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.