How to Change Data in a (2005) System Table?

[JohnBates]

happy Friday!

In 2005's msdb database, I want to "reset" the job history for a job that failed. It runs only every quarter and I have an automated report that runs daily to inform me of any job failures.

In 2000, you could edit the msdb.dbo.sysjobservers rows - in 2005 they have restricted changes to sys tables even more.

Is there a way to modify a 2005 system table's data?

Thanks, John

 

[mrdenny]

What error are you getting? You should be able to update that table. That is a user table not a system table.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog