>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

Not sure if this would be of any help, but just found this link http://www.sqlservercentral.com/articles/Error+Description/65013/