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 |
|
cornall
Posting Yak Master
148 Posts |
 Posted - 2007-06-11 : 07:39:20
|
| Hi,I have a job that shipps logs ever 5 mins. The restore at the other end checks sequence nos and file names of the logs.In both the source and destination directories i had the followinglog_20070611_104500 (applied ok)log_20070611_105000 (missing from my audit table)log_20070611_105500 (in the audit table)I was getting a sequence error as the 10:50 log was not in the audit table thefore the next log expected was the 10:55 log but the next file found was log_20070611_105000.I checked the job history it showed the job sas having run at 1045 and 1055 but not 1050!! This makes no sence as there is a 1050 file and it applied ok when I added it to the audit table!Has anyone seen this beofer whera job has clearly rrun but it isn't in the job history!?!? |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-06-11 : 18:07:27
|
| Seems file copy job ran ok bot not log apply ones. How long did 1045 job take? |
 |
|
|
cornall
Posting Yak Master
148 Posts |
Posted - 2007-06-13 : 15:48:43
|
| Found the problem the sql server restarted during the job. |
|
|
|
|
|
|
Job Ran but No Job History!!