>I want to inform my user if certain jobs have failed. I want to notify the user on their pagger.
Set them up as an Operator under SQL Agent,
then add them to the Notifications tab of the Job as a Page Operator.
[see Books Online for more detail]
Insanity: Doing the same thing over and over and expecting different results.