I am getting the following error while trying to invoke a DB JOB from my application code.
System.TypeLoadException: Could not load type 'Microsoft.SqlServer.Management.Smo.Agent.JobBaseCollection' from assembly 'Microsoft.SqlServer.Smo, Version=220.127.116.11, Culture=neutral, PublicKeyToken=89845dcd8080cc91
I have installed my code in application server and the DB where the sql jobs are installed is in another server. (Different physical servers).
When I analysed, I could see that the Application server has Microsoft.SqlServer.Smo version 18.104.22.168 in its GAC. The DB server has got both 22.214.171.124 and 10.0.0.0 versions of the same DLL in
I wonder whether this can cause the issue.
Any help is appreciated.