DSXchange

Posted: **Tue Mar 13, 2012 1:28 am**

Hi,

I have an requirement like my jobs will execute on hourly basis incase of job getting abort email alert needs to be send , this alerts should be send during non business hours only.
could you please sugestme ho to restrice this in datastage...

Thanks in advance...

Posted: **Tue Mar 13, 2012 2:33 am**

Create job designs that don't abort. Then, if they abort for environmental reasons, you can trap the job status in the controlling sequence and send email based on any conditions you wish. Implement the condition logic in a Nested Condition activity.

Posted: **Tue Mar 13, 2012 3:23 am**

Thanks ray,

Is ther any way to check
if day is not in (sat,sun) and time between (08:00 20:00)
from current timestamp vaue in datastage.

Posted: **Tue Mar 13, 2012 6:00 am**

Of course. But tell me, what happens to these alerts when they happen during business hours? Are they simply ignored, as in not sent?

Posted: **Tue Mar 13, 2012 1:42 pm**

Code: Select all

Left(Oconv(Date(),"DWB"),1) <> "S" And (Time < Iconv("08:00","MT") Or Time() > Iconv("20:00","MT"))

This could be a User Variable definition expression.

DSXchange

Email notification on NON Business hours

Email notification on NON Business hours