Fixed it!

Thanks to these links:

http://blogs.msdn.com/sqlserverfaq/archive/2009/01/30/part-1-sql-server-2005-patch-fails-to-install-with-an-error-unable-to-install-windows-installer-msp-file.aspx

http://kb.acresso.com/selfservice/viewContent.do?externalID=Q105971

The file missing from C:\Windows\Installer\ was "4f74b2.msp"

And I had restored the incorrect version of sqlrun_tools.msp for: "129315a9.msp"

I have been implementing this on our database servers running Windows Server 2003 for about a year now.

There is documentation here: http://support.microsoft.com/kb/929491

All I do is: Partition the disk...

The scheduled tasks setup to run as a Generic Service resource under the same group as SQL Server, so that the scheduled tasks only run on the Active node.

Registry replication...

I have successfully re-run the update.

Select @@version returns:

Microsoft SQL Server 2005 - 9.00.4035.00 (Intel X86)

Nov 24 2008 13:01:59

Copyright (c) 1988-2005 Microsoft Corporation

Standard Edition on Windows NT 5.2 (Build...

Fixed!

I restarted the SQL Server Agent service, and job notifications are now working.

Because SQL Server Agent caches profile information, SQL Server Agent does not immediately use new information when the...