Search code examples
sql-serveremailexesql-job

What is the server IP if SQL job initiating an EXE which is on a network share?

I have an EXE which is on a network share, this Exe is triggered by an SQL job. The purpose of the Exe is to send mails.

So if someone asks me what is the Server IP that is sending the mails. then should I say the IP of the SQL database server? I'm not sure of how to answer this question.

Solution

  • Not exactly, It depends where is the SMTP server which is actually sending the emails. So If the SMTP server and SQL server are on the same machine, then yes IP for both is same.

    If you are accessing a SMTP server which is running somewhere else or you are calling some email service provider to deliver your emails then IP of Mail server will be different.