I wish it had it. I have queried about this before by email to Intel Technical Support in March 2009. Their response was:
Hard disk failures or RAID volume degradations will be notified upon boot (Ctrl + I ) and within the operating system only, through the console. The Intel(R) Matrix Storage Manager Console does not support remote notifications.
Furthermore I asked for an API and Intel's response was:
Regarding writing your own application, it is possible and you can do it. However, we do not offer guidance or support for it.
I found this though - Intel Matrix Storage Manager command line util:
But I am unsure as to whether it works with all chipsets as the readme seems to say ICH9R.