I have sql server 2016 Enterprise Edition. I have created AlwaysOn Group. and added SSISDB. I do have couple SSIS packages running on primary replica with no errors. but when failing over to second replica, the jobs fails.
Asking to create master Key or certificate.
so my question is this: is there a way to automate this and whenever FaillOver happen the jobs should be running as they are on Primary replica?
Thank you all.