Hi Guys,
In this post i will give you some tips that we can use while creating an Email task in ODI 12c.
The main thing that we need to take care while creating an Email task is Email Subject and Email Body. In failure email and all we need to make this dynamic so we will get proper failure email with subject.For that you can use the following codes.
Subject:
<%=odiRef.getContext("CTX_CODE")%> - ODI session <%=odiRef.getPrevStepLog("STEP_NAME")%> in package <%=odiRef.getSession("SESS_NAME")%> FAILED AT <%=odiRef.getPrevStepLog("BEGIN")%>
By using the appropriate odiRef we can customize the subject accordingly.
Message Body:<%=odiRef.getPrevStepLog("MESSAGE")%>
This will give you the failure step description with error codes.
In this post i will give you some tips that we can use while creating an Email task in ODI 12c.
The main thing that we need to take care while creating an Email task is Email Subject and Email Body. In failure email and all we need to make this dynamic so we will get proper failure email with subject.For that you can use the following codes.
Subject:
<%=odiRef.getContext("CTX_CODE")%> - ODI session <%=odiRef.getPrevStepLog("STEP_NAME")%> in package <%=odiRef.getSession("SESS_NAME")%> FAILED AT <%=odiRef.getPrevStepLog("BEGIN")%>
By using the appropriate odiRef we can customize the subject accordingly.
Message Body:<%=odiRef.getPrevStepLog("MESSAGE")%>
This will give you the failure step description with error codes.
No comments:
Post a Comment