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

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

    DONE - Create linked server between S1 and S2..Sn.

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

    Do I use type: T_SQL Script?

    How whould I do the import?

    Thanks