Updating sql 2016
You are running on an older browser version which is not supported.
A number of features on this site will not work properly with this browser.
THIS TOPIC APPLIES TO: SQL Server (starting with 2016)Azure SQL Database Azure SQL Data Warehouse Parallel Data Warehouse This topic describes breaking changes in the SQL Server 2017 Database Engine and earlier versions of SQL Server.
These changes might break applications, scripts, or functionalities that are based on earlier versions of SQL Server.
Issue and customer impact: Microsoft has identified a problem that affects the Microsoft VC 2013 Runtime binaries that are installed as a prerequisite by SQL Server 2016. If this update to the VC runtime binaries is not installed, SQL Server 2016 may experience stability issues in certain scenarios.
For information on what's new, see What's New in SQL Server 2016.This is because you have to manually create the jobs on each server, then modify the jobs on each server to check and see if the database for that job is on the primary server.Well, here’s a T-SQL script which will help solve this problem for you.If you add more jobs later you can run this script again as it will skip any jobs which have this job step already added.To be safe, backup your msdb database before running this.