asked on How to I set an email deployment after my SQL 2005 server backs up
I'm not familiar with creating scripts to my sql server, but i'm trying to figure out how I can setup my server to email me after an error occurs or after a back is done.
Microsoft SQL Server 2005Microsoft SQL Server
Last Comment
JestersGrind
This give full walk through
http://blog.sqlauthority.com/2008/08/23/sql-server-2008-configure-database-mail-send-email-from-sql-database/
http://blog.sqlauthority.com/2008/08/23/sql-server-2008-configure-database-mail-send-email-from-sql-database/
Under the properties of the job, there is a Notifications tab. You can use this to send an email when the job succeeds, fails or completes.
Greg
Greg
ASKER
I am running SQL server 2005 from Microsoft and I don't see any option on any job that gives me the properties tab.
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
you can modify the job to send a mail