Date parsed: 22/10/2007 07:42:30
Date: Mon, 22 Oct 2007 11:42:30 -0400

You can exec sp_help_job and look at current_execution_status.
To stop a job look at sp_stop_job in Books Online.



"Abel" <Abel@discussions.microsoft.com> wrote in message
news:0C4830A1-7C86-45A3-A7D4-1DDCE0E2B8A7@microsoft.com...
> Hi,
> I've scheduled Jobs that sometimes hangs (SQL2005). I want create another
> job that checks these jobs and stop them if needed.
> Is possible to know if jobs are running with a SQL sentence? How stop and
> disable jobs with SQL sentence?
>
> Regards,
> Abel.
>