• Smart and simple.

    I also find using sysjobs_view useful in place of sysjobs. Especially if you are managing more than one server.

    The extra colum originating_Server can tell which server the job failed on.