Off hand, I do not know of any VBScript. However, the VBScript will use ADO to open a database connection, create a ADO command, which will execute a SQL command that returns a Recordset of scheduled events. The VBScript will read each record in the recordset. Each record should have a database column with the e-mail address of the person who scheduled the project. You will then create CDO objects (e-mail objects built into Windows) and send a e-mail message to each e-mail address. Of course the body of the e-mail, should contain the detail of the event.
You want to use a SQL Job not a trigger. A Job runs on a time interval you specify, whereas a trigger runs when either a DELETE, INSERT, or UPDATE SQL statement is run.
NOTE: The the size of the VBSript is limited within the SQL Job. SO be as concise as possible.