Also, if you want that trigger to send you email, you will need to turn on Database Mail (DBMail) in order to use it.
To get you started, here is a simple script to send a message, once DBMail is turned on and set up.
@profile_name = 'SQL Server Agent Mail Profile', -- this should be the actual profile name you give it when set up
@recipients = 'email@example.com', -- use ; between them if more than one
@body = 'This is a test of the emergency broadcast system....',
@subject = 'This is only a test' ;