• You can use linked servers to poll information from all the servers.

    Create you new CentralJobHistory table on server of your choice. (S1)

    Create a new login on each of the instances that has read permissions to the history table. (S2..Sn)

    Create linked server between S1 and S2..Sn.

    Create a job that imports data from S2.msdn.dbo.sysjobhistory to S1.db.dbo.CentralJobHistory.

    ... Thanks.

    Mohit.

    [font="Arial"]---

    Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
    Microsoft FTE - SQL Server PFE

    * Some time its the search that counts, not the finding...
    * I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]

    How to ask for help .. Read Best Practices here[/url].