• Thanks, but I clearly indicated the usage of the extended stored procedure at the beginning of the article:

    In addition, there is an article written by Gregory A. Larsen. http://www.databasejournal.com/features/mssql/article.php/10894_3491201_2  His article shows how to find that any job is running.  But to give the answer "Is job running?" for the particular job the article is using undocumented stored procedure xp_sqlagent_enum_jobs. Microsoft SQL Server has always had nifty undocumented functions that people are tempting to use. However, Microsoft has always recommended not using those functions because they can change in future releases. Using undocumented features rarely burning DBA. But with SQL Server 2005 it may be the issue. 

    Please read the article carefully. This proc is undocumented. I am trying to show the way to stay within the documented boundary.

    Leo P.