1

We are using a local area network and we send emails through Outlook via Exchange Server.

My question is can I get SQL Server job failure notification emails in Outlook via LAN (without an Internet connection)? And if yes, how?

  • 1
    Does the SQL Server box have a route to your Exchange server? – Philᵀᴹ May 9 at 8:32
1

You just need to enable mail profile and get the email exchange server IP and listening port as well as a valid active directory mail account for setting up email alert notification for jobs as well as alert on multiple things(dis.

Please check below link for setting up mail profile and operator:

https://www.mssqltips.com/sqlservertip/1523/how-to-setup-sql-server-alerts-and-email-operator-notifications/

https://sqlbackupandftp.com/blog/how-to-set-up-sql-server-email-job-notifications

For setting up notification on alerts:

https://www.sqlshack.com/create-configure-sql-server-agent-alerts/

Hope above helps.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.