Emails not sent if a single bad email address is found

Emails not sent if a single bad email address is found

This question is answered

I am running telligent community 6.0.121.21915.  It seems that if an exception occurs due to an invalid email from one of the forums subscribers, no email is sent to any subscriber.   Is there away to ignore invalid email addresses and allow the system to send emails to all valid addresses?

Verified Answer
  • After 10 tries the email is discarded so you probably don't have many emails in the queue.  You can remove any jobs from the queue with SQL.  Something like this:

    DELETE t

    from QRTZ_DYNAMIC_TRIGGERS t

    INNER JOIN QRTZ_DYNAMIC_JOB_DETAILS d ON t.JOB_NAME = d.JOB_NAME

    where JOB_CLASS_NAME LIKE '%MailGateway%'

    delete from QRTZ_DYNAMIC_JOB_DETAILS where JOB_CLASS_NAME LIKE '%MailGateway%'

All Replies
  • Hi Steven,

    There isn't a way to ignore invalid emails.  Do you know which email(s) are invalid?  I would recommend looking in the database for the invalid email and correcting it.

  • ok, thats unfortunate.   Once I clear out the invalid emails, i don't want a months worth of backlogged  e-mails sent.  Is there a database table that holds all the emails waiting to be sent?

  • After 10 tries the email is discarded so you probably don't have many emails in the queue.  You can remove any jobs from the queue with SQL.  Something like this:

    DELETE t

    from QRTZ_DYNAMIC_TRIGGERS t

    INNER JOIN QRTZ_DYNAMIC_JOB_DETAILS d ON t.JOB_NAME = d.JOB_NAME

    where JOB_CLASS_NAME LIKE '%MailGateway%'

    delete from QRTZ_DYNAMIC_JOB_DETAILS where JOB_CLASS_NAME LIKE '%MailGateway%'

  • Had your issue been solved???