We migrated the databases and jobs from sql 2005 to SQL 2016 and the collation of sql 2016 is "SQL_Latin1_General_CP1_CI_AS" and sql 2005 is "Latin1_General_CI_AS" and all the databases in sql 2016 is having the same collation SQL_Latin1_General_CP1_CI_AS", When we tried to run a job which is configured on master to check the database connections getting error as
Cannot resolve the collation conflict between "Latin1_General_CI_AS" and "SQL_Latin1_General_CP1_CI_AS" in the equal to operation. [SQLSTATE 42000] (Error 468). The step failed.
how to resolve this issue