DTS package running under SQL 2000 not running as scheduled.

• jasons 77446

  Grasshopper

  Points: 23

  More actions

  January 3, 2012 at 2:30 pm

  #265719

  I have a dts package that needs to run daily. The package just queries information from the database and dumps it into an excell spreadsheet. I doesnt run. I can maually run it and it works just fine but when I try to run it scheduled it does not run. I have recreated the package and still same problems. Any thouhgts?

  Jason

• homebrew01

  SSC Guru

  Points: 55548

  More actions

  January 4, 2012 at 7:28 am

  #1428296

  So you have it scheduled for a specific time (eg 6:00 am), but it never runs or fails ?

  Does the job run manually ? Or the DTS by itself ?

  What does the "Last Run" column say ?

  Are you sure the Job AND the Schedule are BOTH enabled ?