scheduling the SSIS jobs

• VRT

  SSCertifiable

  Points: 5776

  More actions

  May 13, 2015 at 7:58 am

  #296962

  Hi

  I have Packages in Integration Service Catalog (SQL Server 2012) and I used project deployment and I want to schedule to run daily and weekly.

  I need a guidance on how to do it. I don't see any option to schedule it.

  I don't see SQL Server Agent also, may be I don't have permissions to schedule.

  Thank You

• Phil Parkin

  SSC Guru

  Points: 246986

  More actions

  May 13, 2015 at 8:01 am

  #1797555

  VRT (5/13/2015)

  ---

  --

  I don't see SQL Server Agent also, may be I don't have permissions to schedule.

  This sounds very likely.

  The absence of evidence is not evidence of absence.
  Martin Rees

  You can lead a horse to water, but a pencil must be lead.
  Stan Laurel

• SQL.AP

  Hall of Fame

  Points: 3244

  More actions

  May 14, 2015 at 9:10 pm

  #1798071

  Get SQL Agent permission first. Then you can create a SQL job to schedule your SSIS package.

  ____________________________________________________________

  AP