Using the SCOME technique, the DBA can retrieve data on any failed jobs that may have occured on any of the remote linked Servers. For example, this report retrieves the following:

All SQL Server Agent jobs on all linked servers that have failed since the last data gathering. SQL Server Log entries that contain the keywords "failed" or "error" can be called for the corresponding server, as well as Maintenance Plan Logs and SQL Server Agent Logs with such keywords. For the SQL Server Log, a log cycle number of 0 to 6 can be specified.

Use SCOME to interrogate the following tables to retrieve data on failed jobs from all linked servers: 

Failed Jobs History
msdb.dbo.sysjobservers, msdb.dbo.sysoriginatingservers_view, msdb.dbo.sysjobs, msdb.dbo.sysjobhistory

Failed Maint Plans
msdb.dbo.sysmaintplan_log, msdb.dbo.sysmaintplan_subplans, msdb.dbo.sysmaintplan_logdetail

Failed Entries in SQL Server Logs
Use master.dbo.sp_readerrorlog @p, where @p is the log number, to retrieve log entries, and then search for failed events using keywords.

Please enable browser pop-up windows for this page. This help guide can be hidden by clicking the minimise icon on the top right.