Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 SQL Job configuration error

Author  Topic 

sharathsuman
Starting Member

2 Posts

Posted - 2008-07-16 : 13:36:40
Hi,

I have created a SQL Job and have configured to run daily. The job was being executed successfully till last two days, and is failing from last two days. The logs says that the "The process cannot access the file because it is being used by another process. Process Exit Code 1."

There are no other jobs on the server except this one. The only single step in the job is a batch file consists of a sequence of steps, but when I execute the batch file directly it executes properly.
Could you help me out in figuring out the problem

Thanks in Advance

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-07-16 : 13:40:47
Maybe somebody is accessing file while kicking job to start.
Go to Top of Page

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-07-16 : 22:40:29
Was windows backup or anti-virus running?
Go to Top of Page
   

- Advertisement -