DTS Package Hung

• chriskesler1

  Grasshopper

  Points: 12

  More actions

  January 24, 2003 at 8:20 am

  #357689

  Is there any clever way for a DTS package to be monitored? The problem we are having is that we use a large number of DTS packages to import and export large quantities of data in flat file form via Jobs setup in SQL Agent. Sometimes, however, a Job will hang due to network issues or something of that sort. Is there any way to monitor a hung DTS package from a Job or other application (Third Party) and restart the Job Step without any manual intervention?

• January 27, 2003 at 8:00 am

  This was removed by the editor as SPAM

• philcart

  SSC-Forever

  Points: 47794

  More actions

  January 28, 2003 at 3:12 pm

  #447415

  I don't think you'll find anything that automated. Restarting the job would mean it has to finish first, either successfully or not.

  If package logging has been turned on, you could rig something up to monitor the sysdtspackagelog and sysdtssteplog tables in the msdb database.

  Thanks

  Phill Carter

  --------------------
  Colt 45 - the original point and click interface