February 10, 2017 at 8:51 pm
Hi all,
As the topic goes, I am not referring to auto mated job syncing between the primary and secondary replica, I do not mind manually creating the jobs on the secondary replica.
However, i would like to know if there is a discrepancy in the amount of jobs between the 2 replicas(e.g. primary has 4 jobs while secondary only has 3).
Are we allow to create a database link aka link server from the primary replica to the secondary replica and queries/joins their sysjobs table to find the odd one out ?
Or please advise if there is any other better way to do so.
Thanks!
February 10, 2017 at 10:48 pm
szejiekoh - Friday, February 10, 2017 8:51 PMHi all,
As the topic goes, I am not referring to auto mated job syncing between the primary and secondary replica, I do not mind manually creating the jobs on the secondary replica.However, i would like to know if there is a discrepancy in the amount of jobs between the 2 replicas(e.g. primary has 4 jobs while secondary only has 3).
Are we allow to create a database link aka link server from the primary replica to the secondary replica and queries/joins their sysjobs table to find the odd one out ?
Or please advise if there is any other better way to do so.
Thanks!
Why don't you just try to set up a linked server and see what happens? Its not like you will melt the server down if it is disallowed. 🙂
Another possibility if you need more detail about job differences is to script them out and do a text comparison. The only differences should be the various GUIDs I would think.
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
February 12, 2017 at 9:31 am
Hi Kevin,
The link server will have to be created on a production and i am afraid if that the will break things up.
But you are right, I am lacking of a test environment for alwayson and I think I need to have that to test the above.
But on conceptually, is this the right way to do it ?
Regards,
Noob
February 12, 2017 at 7:10 pm
szejiekoh - Sunday, February 12, 2017 9:31 AMHi Kevin,The link server will have to be created on a production and i am afraid if that the will break things up.
But you are right, I am lacking of a test environment for alwayson and I think I need to have that to test the above.
But on conceptually, is this the right way to do it ?
Regards,
Noob
Yep. And as long as they were named the same you could even do some other checks other than just a gross count.
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply