This was interesting issue which I faced in one of my production environment. Customer complained their all SSIS jobs are running multiple times at a schedule. But in job history, it was showing all well.
We found, all the scheduled Backup maintenance jobs also triggering two times at a schedule.
We tried below options...
1. Dropped old job schedule and created new with same details.
Result: Issue not fixed.
2. Scripted out the jobs and drop and recreate it.
Result: The same, issue not fixed.
Now the situation was interesting, poor app DBA were deleting duplicate data from back-end and their frustration level was getting high day by day.
Finally we found there was a VM clone of the server exists in the network with different name which was requested by customer. Haha ha.
Their jobs which are having SSIS packages connecting to the live production box.
No comments:
Post a Comment
If you have any doubt or question, please contact us.