One option would be to create linked servers and then to create a view where you could do a union all to link tables together.

Create a linked server:

sp_addlinkedserver

@server='Target1',

@srvproduct='',

@provider='SQLNCLI',

@datasrc='SERVER'

Create a view to use the linked server:

CREATE VIEW vw_AllJobHistory

AS

select * from target1.msdb.dbo.sysjobs sj

inner join target1.msdb.dbo.sysjobhistory sjh on sj.job_id=sjh.job_id

union all

select * from target2.msdb.dbo.sysjobs sj

inner join target2.msdb.dbo.sysjobhistory sjh on sj.job_id=sjh.job_id

GO

.... Looks like i have been beaten to it ....:blush: