ms-techie (2/23/2014)
Now in this scenario, we get the following error
"The process cannot access the file because it is being used by another process " and then the job fails . This is because DTExec.exe Process is being accessed by many jobs
Pls help
It looks like they are trying to access the same file simultaneous. It might not be dtexec. Or does the error explicitly mentions that ? Could you post the whole error ..
--
SQLBuddy