• anusql74 - Monday, April 16, 2018 2:56 PM

    Hi Sue ,Thanks for reply ,

    Make sure the target servers are configured as targets - query msdb.dbo.systargetservers on the master. 
    Then check to make sure the job was downloaded to the targets - query msdb.dbo.sysdownloadlist on the master. 
    If all of that seems in order, you can try to force a synchronization of the jobs between master and target by executing sp_resync_targetserver on the master in msdb. 

    but yes all this is already done but only issue is only one server is writing to Central repository table whereas it should be populated from output of all servers .

    Yes...thanks. I get the issue just wanted to check if everything is configured and that you have resynced.
    So what happens when you execute just the query manually on SQL2 and SQL3?

    Sue