Since last few weeks most of the scheduled jobs are not working on the live webserver.
These are basically a VB project.EXEs which gets triggered every wednesday night to import and export data.
I think something went wrong when I tried to move the complete website from the Dev to the Live environment and I think the database reference has been changed or something else.
I wanted to debug them to find out where and what is the error.
On the live I do not see the actual code of these EXEs, I can certainly find them on the DEV server. What I dont understand is whether one have generated EXE on the server or it could have been copied from the Dev to the LIVE server ? If they have been copied then database details on the dev is different than
to the one on the server.
Its keep happening every other week making things more complicated.
When trying to connect from SSMS v17.x to a SQL Server Integration Services 2016 instance or previous version, you get the error “Connecting to the Integration Services service on the computer failed with the following error: 'The specified service …