First you have to find the cause of those hangups. After that you can decide if it possible to fix it in the current process or move to something else.
>
>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?
>
--sb--