Job Execution "Failed"

Hello,
I've created one job, sometimes after the job has been
started, the job stays frozen(the job never ends). To
resolve this situation i need to restart SQL Server Agent.
I would like to develope one script or create one alert
that tell me information when this job get frozen again
but.. i dont know how. I try to check information in the
msdb..sysjobschedules but i cant do anything to reslve
this situation with the info returned.
Help me.. thanks
Best Regards
I'm not sure if there's any out of the box feature that does that, but in
case no one comes up with anything better, you could implement a log table
that tracks the progress of the package and have another package dedicated
to reading the log & sending alerts if a package takes too long. This might
be a kludge, but it would at least be flexible and allow you to check step
execution timings etc.
Regards,
Greg Linwood
SQL Server MVP
"CC&JM" <anonymous@.discussions.microsoft.com> wrote in message
news:c0ac01c4382d$488fe490$a301280a@.phx.gbl...
> Hello,
> I've created one job, sometimes after the job has been
> started, the job stays frozen(the job never ends). To
> resolve this situation i need to restart SQL Server Agent.
> I would like to develope one script or create one alert
> that tell me information when this job get frozen again
> but.. i dont know how. I try to check information in the
> msdb..sysjobschedules but i cant do anything to reslve
> this situation with the info returned.
> Help me.. thanks
> Best Regards