Yes, but I don't remember how. Fire up SQL Profiler and then use the SEM to check on the jobs. Then review the profiler output to find the stored procedure that is used.

-Mike

>Hi All:
> Is there a way I can tell programmically the status of my job without going through Enterprise Manager/Sql Server Agent and viewing job history?
>
>Thanks
>MA