how shedule a package

• Mani-584606

  SSChampion

  Points: 11788

  More actions

  April 2, 2008 at 10:02 am

  #123268

  hi,

  I creaated a package,but I need to run it in night times, so what are the steps to schedule a package.

  thanx

• manfred19551

  Old Hand

  Points: 328

  More actions

  April 3, 2008 at 6:59 am

  #797767

  hello,

  you have to do this in Management studio under the SQL Server agent. There you find the point 'jobs'.

  Add a new job and under the second page (job steps), add a new. Then you can choose under 'type'

  'SQL Server Integration Services packages'.

  Fill in the essentials for your package. In one of the next pages you see 'schedule'. Configure this for your needs.

  regards

  manfred