Could we add additional checks to see if the SQL Agent Jobs are MSX/TSX jobs? I want to use this to sync AG servers but not have the errors involved when it tries to sync MSX agent jobs.
Is there a command that is similiar or close to what you are looking for?
Yes
Technical Details
maybe we filter out the sysjobs based on the category_id != 1 or originating_server_id != 1?
at least that is what seems to show on my target server from 2008R2 to 2022 SQL.
Summarize Functionality
Could we add additional checks to see if the SQL Agent Jobs are MSX/TSX jobs? I want to use this to sync AG servers but not have the errors involved when it tries to sync MSX agent jobs.
Is there a command that is similiar or close to what you are looking for?
Yes
Technical Details
maybe we filter out the sysjobs based on the category_id != 1 or originating_server_id != 1? at least that is what seems to show on my target server from 2008R2 to 2022 SQL.