1 Reply Latest reply on Jan 30, 2017 1:24 PM by CraigMiddelstadt

    how can i resend mail that has failed?

    Sue Rookie

      This morning a DNS setting was changed on our mail server and 3 hours worth of outbound messages failed. The 'retry count' was set at 2. I changed it to 3. Is there a way to select those messages to be reprocessed? or Can I use an update command to change 'email faled' to false? is there any way to get these emails out?

        • 1. Re: how can i resend mail that has failed?
          CraigMiddelstadt Master

          --Force Resend on Unsent messages

          --*************************************************************

          update tps_user_message_recipient set tps_email_failed = '0' where tps_email_failed <> '0' and tps_is_email_sent = 0 and tps_email_address is not null

          update tps_user_message_recipient set tps_next_retry_datetime = NULL where tps_is_email_sent = 0 and tps_email_address is not null

          update tps_user_message_recipient set tps_retry_count = '0' where tps_retry_count <> '0' and tps_is_email_sent = 0 and tps_email_address is not null

           

          Craig Middelstadt

          Senior ITSM Consultant