Show's the run status of each sql agent job's last 5 executions..

USE MSDB

DECLARE @PrevRuns TINYINT

SET @PrevRuns = 5

SELECT

Name

, Description

, message

, run_status

, RunDateTime

FROM (

SELECT

j.Name

, j.Description

, h.message

, h.run_status

, msdb.dbo.agent_datetime(run_date, run_time) as...

The only way I can think how to do this is to build the top 10 query into the model - add another copy of the table in Data Source...

I'd have to pick ( a second nod to Nick Cave here )..

Brainiac - Hissing Prigs in Static Couture

Roky Erickson - I Have Always Been Here Before (Anthology)

Velvet Underground -...

If you're on 2005, you could move both databases into one and separate the tables with schemas, and then use foreign keys for integrity. You could do the same with...