can somebody help me to setup email alerts in SQL Server 2000 standard edition whenever, backup is successful OR failed to complete.
Thanks,
I'll assume you're doing scheduled backups via SQL Server Agent
1. Configure SQL Server to use SQL Mail (Check Books Online SQL Mail)
2. Add an operator to SQL Server Agent with the relevant email address
3. In your SQL Job, notifications tab, check the box to email, select your operator and also selec to alert whenever the job completes.
HTH!
No comments:
Post a Comment