whats the output of the job step, not the overall job

The only thing that stands out is the name "SP_RMT" I take it that, that object is a Stored Procedure via the prefix "SP".

If so you cant select direct from...

you cant get the versions of the shared features that way

run the SP2 installer or the CU installer and screen shot the part where you select the features to patch...

You sure it was 2016wSP2 in the media that installed it, the summary file shows the shared features are at a lower level than SP2.

Run the SP2 installer when you...

You need to alias after the delete to know where to delete from.

If you had a DELETE with multiple joins in the logic to only delete the right rows, you...

Well looking at the summary log, the shared features don't seem to have been updated past the RTM version so whoever did the initial patch to SP2 seems to have...

Sounds like you've run into the new cardinality estimator issues that everyone had who upgraded from 2014 onwards.

When you rebuilt your statistics did you rebuild with a fullscan or was...

Proc usage is tricky as it all depends on how volatile your procedure cache is.

If your constantly flushing plans then the procedure stats wont stay around for long.

But it is...

can you post the summary log

do you have Always On Availability Groups configured with SSISDB as part of one of the groups?

For an Azure database assuming its Azure SQL Database the PaaS offering "database.windows.net" you need to set the Database to connect to as part of the connection string or options...

The user must exist as a login on both sides (unless your in contained database territory)

You then also need to ensure your licensed correctly, as allowing a user access to...

You could just get logshipping to apply the logs to all the nodes in the AG setup.  What I haven't done though is put a DB into a AG from...

If all your wanting to do is to basically add resiliency on your primary site then the best way would to just add in the two new VMs as nodes...

You would be able to log ship to the primary node of the availability group, you just wont be able to add the databases into the group until after the...

Whats the full error message you get.

Renaming disabling the actual SA account is fine jobs can still be owned by that account, that is what I do on my servers...