There is a new MP added to the downloads section called Alert on Pending Actions that create an alert when there is a pending action in the Ops Mgr 2007 Console. The script that performs the SQL query is “parameter free” and is scoped to run from the Root Management Server only. The MP contains a rule to run the script and another rule to alert on a specified event.

You can find the download here.