Cancel Queued Emails and Delete tickets

  • Used Zammad version: 6.0
  • Used Zammad installation type: package
  • Operating system: ubuntu

Self-Hosted

Is there a way to cancel specifically all queued email delayed jobs from a specific Microsoft 365 channel and delete tickets that it created within the last 2 days? We had an authentication issue (on Microsoft’s end) about 4 months ago, so we set up a new account and rerouted our incoming to go to the new inbox. The email admin kept the emails still incoming into the old inbox as well.

We had an ISP and server location change while I was away the past two days, and I return to find out the tech that performed the move didn’t follow the instructions, and turned back on the original Microsoft 365 channel and the correct one, and lo and behold, it no longer had authentication issues. So it created duplicate tickets and started sending out responses, etc…

And if that wasnt enough, the server backup job started failing a few days into my vacation and wasn’t fixed before the move, and the new location has no VPN access as yet so it has to wait until I’m in front of the box and pull out the rack monitor and peripherals.

Will deleting that channel clear its queued jobs? Is there a way to delete only those tickets created in the last 2 days from that specific channel? Will deleting select entries in the delayed jobs table work, or is that just an informational table?

Please delete this question. I found a working solution by poking through the code; I don’t recommend it to the faint of heart.

Unspoken IT Sorcery :frowning: