Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

System Profile

...

  1. Go back to the “CAWIS Attachments” page.

  2. Select the template to edit and click on “Upload”.

  3. Upload the file using the “Browse” button. DO NOT check the “Update filename” checkbox.

  4. Click on “Save”.

Validate the HTML template

...

Basically, we're searching AA003 for failures ( notification status = 3 )  where the client had a legitimate looking email.  This success/fail info will be available to CAWIS admin, on the AAIRDATA report, next day

Yes, it is possible that there were NO bad emails in the EDM run, but this would be a very rare occurrence.

SELECT * FROM AA003_NOTIFICATION_ATTEMPT

WHERE PROCESS_YEAR_MONTH_NUM = 'YYYYMM'

AND NOTIFICATION_TARGET_LBL NOT IN ('Blank Email Address',

'Failure due to notification preference' ,

'failure due to SMTP Error' )

AND NOTIFICATION_STATUS_CD = '3' ;