March 24, 2003 at 9:50 am
Last night two sql 7 servers can down with the same problem: the nightly database dumps completed successfully (as shown by the contents of our dump folder) but the Database Maintenance Plan History did not show any record of success or failure. Under the Maintenance Plan "Reporting" tab, "History on this server", we have a default limit of 1000 rows for msdb.dbo.sysdbmainplan_history. History is nice but I need more current information. Now I can delete one line at a time from this history from the list but this is
ridiculous. Can I simply delete the contents of this table in QA or am I asking for trouble? (I prefer not to increase the default row count allowable for sysdbmainplan_history.)
TIA,
Bill
March 24, 2003 at 10:07 am
SQL Server trace has confirmed the deletion of single history line from EM touches table 'sysdbmaintplan_history' only. I can't think anything else need to access/use this table.
March 24, 2003 at 10:28 am
Another finding: under "EM > Management> Jobs> (right-click on the job of interest)>View Job History" seems to draw from a table other than sysdbmainplan_history.
Anyone know where?
TIA,
Bill
March 24, 2003 at 2:05 pm
sysjobhistory
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply