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 |
|
ygeorge
Yak Posting Veteran
68 Posts |
 Posted - 2003-06-30 : 11:50:51
|
| I have a backup job on SQL Server 2000. It runs every midnight. I can know the database is backuped last night by looking at the timestamp of the backup file. But the job history is not logged. I can only see the job history of three days ago. The only thing happened on that box is we installed a OLAP Analysis service and then uninstalled it. Any idea why it doesn't the job history?Thanks,George |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-06-30 : 13:26:29
|
| Is the message that the BACKUP completed listed in the SQL Server Error log? Job history is stored in msdb.dbo.sysjobhistory. Check if there is a record for your backup. If not, then investigate permissions. I would also ensure that the job is enabled and scheduled. You can do this by looking at the job properties or you can look at msdb.dbo.sysjobs and msdb.dbo.sysjobschedules.Tara |
 |
|
|
Shastryv
Posting Yak Master
145 Posts |
Posted - 2003-06-30 : 15:24:47
|
| I guess in 6.5, i observed the same behavior. If I remember correctly DBCC CHECKIDENT('sysjobhistory') fixed my prob. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-06-30 : 17:37:20
|
| Ah 6.5, the good ol' days. Back in 6.5 it was much harder for a non-DBA to pretend to be a DBA than it is now.Tara |
|
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2003-06-30 : 19:35:37
|
quote:
Ah 6.5, the good ol' days. Back in 6.5 it was much harder for a non-DBA to pretend to be a DBA than it is now.Tara
Tara! What are you saying! The mere thought of it... Brett8-) |
|
|
|
ygeorge
Yak Posting Veteran
68 Posts |
Posted - 2003-07-01 : 11:11:21
|
| ...LOL...That's fine with me. I'm just not lucky enough to born as early as you guys :-) |
|
|
|
|
|
|
Job history not logged