There is no automatic method (i.e. method builtin to the SQL Anywhere product) that will send an email when a mirroring failover occurs, but you can easily do this yourself using the tools provided. Here is one method that you could use to send an email when a failover occurs:
See the documentation that I have linked for more information. The basic idea is that the MirroringFailover event will be triggered on the new mirroring partner when a failover has occurred. In the event you can do whatever you want: in your case you would simply use xp_sendmail to send the email to the recipient(s). The xp_sendmail documentation page shows an example on how to send email. |