It is "a custom event-based notification system designed to reduce the number of database queries made by the BlackBerry Enterprise Server to the BlackBerry Configuration Database." ... from
Install a server based notification service on a remote SQL server
To update it I believe you'll need to stop the SQL Server service. That said, if the documentation doesn't say to update it; I wouldn't update it.