Hi All,

Is there a way to handle a scheduled job which hangs for the extended period of time? I have some overnight scheduled jobs in SQL Server 2005 which extract data from the mainframe system. In some cases those jobs indicate a failure which I can handle but sometimes they just hang and never completes.

Is there a way to handle situation like that for example using SSIS?

Thank you,
DAniel