• Your into the inner workings now of how SQL Agent passes the subject from the Agent alert system to sp_notify_operator. My best bet would be for you to create your own email step within the job to send an email when a step fails by using the on failure actions of the other steps, and passing in the FQDN using powershell as you cant get the FQDN from SQL itself, you need to get it from the Windows host.