• I'm using sql 2008 sp1.

    I do not get an error if the job is not running (EXEC [master].dbo.xp_sqlagent_enum_jobs 1, 'domainname\lawrence', 'B508F33F-8C69-42B9-9635-4CA66C05548D').

    If the job is running I get the above error.

    If I run this script and job is not running with "Alert", it sends a message to the Operator that the job has been running and the is stopped and disabled.