RSS Reporter for SQL Server

Job-detail feeds

 

A job-detail feed contains one entry for each step included in the job. In the case of historical job status feeds the feed includes one master entry for each execution batch and one sub-entry for each step on that batch (job). Each entry in the job-detail feed contains:

• Title - Start Time, Completion Time, Status
• Step ID - The id of this step in the context of the job
• Step Type - SSIS Package, ActiveX, Other
• Command - The command that this step executes
• Run Date - Time when this step ran
• Status - Status of this step, failed, succeeded
• Duration - Time it took this step to complete
• Description - the user under the authority of which the step was executed and the status

You can reach a job-detail feed by drilling on a job on a current or historical job status feed or you can reach it directly. Just like with the other feeds you can search on a job level feed as well as filter and sort it.