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