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.
| Author |
Topic |
|
Sarat
Constraint Violating Yak Guru
265 Posts |
 Posted - 2003-03-14 : 12:29:49
|
| Hi!I have an update stats job scheduled for every thursday at 7.45 PM. This job bothered me for few weeks as I couldn't figure out why my database backup on thursday night would occur so late (11.45 instead of 9 PM). I guessed this by checking the maintenance plan details which I ignored first as I was under the impression that whatever job runs on server will get written to error log file. I never saw an entry for this job until now. Q1 -> Shouldn't this job have an entry on error log as others (like backups, rebuilding indexes have)?Q2 -> This job also writes a report after successful completion of job. But the report always shows time taken to complete this job is 1 sec(s) which is weird because if you look at the report file modified date, it is after 2 hrs of job has started! What really is happening?Thanks,Sarat. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-03-14 : 12:36:45
|
| Don't know what is happening with your job without be given further details, but to answer your question about jobs writing to the error log, the answer is no. Not all jobs write to the error log. Pretty much the only jobs that do write to the error log are the ones that you have already listed, plus integrity checks and restores.Tara |
 |
|
|
|
|
|
Update Stats job won't write to error log