jdr0606
asked on
SQL005 Jobs Not working as normal
I have a SQL2005 job that restores some databases that has been running for at least a year with problems.
About a week ago the first restore in the job started taking 10 times longer to run but the following restores seemed to run normally. Thinking that it might have something to do with the database I changed the order and used a different database as step #1. With the order changed and a different database as Step #1 that database took 10 times longer to run and the previous #1 ran as normal.
The entire job does complete but instead of 2 hours it now takes 5 hours.
The other interesting thing is that normally I can "view history" while the job runs and watch as each step executes however now I can't see anything about the job execution until after it has completed.
Ideas?
About a week ago the first restore in the job started taking 10 times longer to run but the following restores seemed to run normally. Thinking that it might have something to do with the database I changed the order and used a different database as step #1. With the order changed and a different database as Step #1 that database took 10 times longer to run and the previous #1 ran as normal.
The entire job does complete but instead of 2 hours it now takes 5 hours.
The other interesting thing is that normally I can "view history" while the job runs and watch as each step executes however now I can't see anything about the job execution until after it has completed.
Ideas?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
just ignore this - wrong post
ASKER
Accepted answer: 0 points for jdr0606's comment #a39478079
Assisted answer: 250 points for angelIII's comment #a39459312
Assisted answer: 250 points for EugeneZ's comment #a39462138
for the following reason:
While the input from the experts was helpful, at the end of the day it was determined to be something not likely related to the original request.