Scheduling SSIS Package for execution

  1. Launch SQL Server Management Studio.
  2. In the Server type, select Database Engine.
  3. Specify the Server Name where Database Services is installed.
  4. Under the SQL Server Agent tree, locate the Jobs folder.
  5. Select Jobs, and then right-click it to start the Job creation process. The information in the General, Steps, and Schedules pages is required.
  6. Specify the Job Name.
  7. Select the Steps page and then click the New to add a step and specify this information:
    Parameter Value
    Step Name ex. HRCM BI SSIS
    Type SQL Server Integration Services Package
    Run as SQL Server Agent Service Account
    Package Source SSIS Catalog
    Server Server Name. For example "." for local server
    Package Click the ellipsis (…) to select the package that is being deployed to Integration Services Catalog in the previous step. For example, “\SSISDB\HRCMBISSIS\HRCMBISSIS\CDNHosp_ETL.dtsx”
  8. Select Schedules.
  9. Click New to configure the timing for the update. Select a time after the Day End processing is completed.
  10. Click OK to schedule the job to perform the updates.