• You may use a custom query which monitors the job status. This query gives the status of a given job

    EXEC msdb.dbo.sp_help_job @Job_name = 'The Job Name'

    The following tables hold all the information about the jobs.

    msdb.dbo.SysJobs

    msdb.dbo.SysJobSteps

    msdb.dbo.SysJobSchedules

    msdb.dbo.SysJobServers

    msdb.dbo.SysJobHistory

    Pradeep Adiga
    Blog: sqldbadiaries.com
    Twitter: @pradeepadiga