Link to home
Start Free TrialLog in
Avatar of jdr0606
jdr0606Flag for United States of America

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?
SOLUTION
Avatar of Guy Hengel [angelIII / a3]
Guy Hengel [angelIII / a3]
Flag of Luxembourg image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of jdr0606

ASKER

I've requested that this question be closed as follows:

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.
just ignore this - wrong post