Unanswered: SQL Server 2012 SE Mirroring Failover Notification
I am using Standard edition SQL Server 2012 and I have Mirroring in place and working. I have a Principal, Witness, and Mirror all in place. I want to set up a email notification to email me to let me know when/if the Principal fails over to the Mirror , and visa-versa.
I already have under SQL Server Agent . Operators > <User for notifications> this is pointed to a email Engineering alias company email address.
So what do I set up to actually see this type of event?