Performance - email delivery time from UNIX

[mathewse111]

I have program which analyses the data and create report. If we look at the execution of queries it takes only 35 minutes for SAS related queries and all. In the end the program send the report to outlook email from Unix SAS. Sometimes by the time we receive the email, it takes almost an hour and a half. Is there any known solutions ?

[Kurt_Bremser]

How large is the report attachment?

[mathewse111]

Around 50 KB

[Kurt_Bremser]

---

@mathewse111 wrote:
Around 50 KB

---

So this can't be the reason. Get in touch with your mail admins.

[mathewse111]

38-50 KB

[SASKiwi]

So the entire SAS program runs in an elapsed time of 35 minutes, including the DATA step sending the email, but the email transmission takes 1.5 hours? This sounds like more of a question for your email system administrator. 

[mathewse111]

When I review the logs, and add up the execution times , it adds up to 35 minutes, but the time difference between execution started and the email delivered is 1.5 hours.

[mathewse111]

When I review the log, execution time for sas statements is around 30/35 minutes. But the email is received after 2 hours or more. The sas program sends an email from a program running on a UNIX and the emails are sent to outlook running on Windows machines.

[Kurt_Bremser]

How long does the step that sends the mail take? Is it a DATA step with FILE EMAIL, or ODS with an EMAIL file reference?