0

I have a job which does some matching but may produce duplicates. When this happens, I want the job to create a table containing these duplicates and send an email with the data.

Putting aside the conditionality for the moment (on whether duplicates were actually produced), I can't even seem to get the email to send.

I have tried selecting a Publish to Email transformation and follow this link as best as I could, but I get the errors

ERROR: Email host ****** not found ERROR: Unable to publish package to email address ****** ERROR: EMAIL transport engine encountered errors while publishing the package. ERROR: Email host ****** not found. Package end successful

where ****** are strings that I am obscuring. One issue is that the mentioned link asks me to show the output tab, but checking the indicated box has no effect and the output tab still cannot be seen. I do not know if this is what is causing my error.

Much Gratitude for any help with this.

UPDATE:

I can now get the output tab to display. Toggling the option only takes effect after closing and reopening the job. The other (main) issue remains.

Joe
  • 62,789
  • 6
  • 49
  • 67
Rookatu
  • 1,487
  • 3
  • 21
  • 50
  • Are you able to send automated emails via the host in question using any other application? – user667489 May 15 '15 at 18:11
  • Not that I know of. I asked a colleague if he can do it in SAS EG and he said he can't and that he gets the same error. Another colleague believes that it's a permissions thing and that the feature probably isn't part of our license. Any idea if that hypothesis might be correct? Thanks! – Rookatu May 15 '15 at 19:51
  • Are you able to send emails using base sas code? i.e. via `filename email`? – user667489 May 15 '15 at 19:54
  • please reach out to your SAS administrator for this. Either email options have not been setup correctly in SAS or maybe your SAS admin does not want any emailing to be done from your SAS server. – sushil May 17 '15 at 06:19
  • Thanks sushil. That turned out to be what was needed. You can post your suggestion as an answer and I will accept. – Rookatu May 25 '15 at 14:38

1 Answers1

1

Please reach out to your SAS administrator for this. Either email options have not been setup correctly in SAS or maybe your SAS admin does not want any emailing to be done from your SAS server.

sushil
  • 1,576
  • 10
  • 14