Home Forums SQL Server 7,2000 Working with Oracle Jobs (DTS packages) hangs after Oracle Goes down ... RE: Jobs (DTS packages) hangs after Oracle Goes down ...
Arpit Goel
SSC Rookie
Points: 41
More actions
December 30, 2009 at 10:41 am
#1097565
this was resolved after recycling sql mail which was causing jobs to hung while sending alerts but there was no way to stop and start hung jobs.
DBA team had to recreate jobs to resolve it and recycling sql mail resolved issue with alerts.