Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SQL job email notification/alerting options

Status
Not open for further replies.

thriverIT

MIS
Feb 7, 2003
15
0
0
CA
Hi All,

I am finding my options in implementing alerts/notifications in case a sql job (maintenance or application related jobs) fails.

We have Windows 2003 and SQL Server 2000 environment. In a test machine with outlook 2003 (email acct. configured is connecting to an exchange server), testing of auto-notification is configured and tested and it will satisfy our need. My concern is... will it be safe to configure and install Outlook in a production environment or it's too risky?

Is there any other ways to setup auto-notifications/alerts when a sql job fails without the outlook option?

Thanks,
thriverit


 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top