Clear Email Queue without sending emails

[Kundan960]

Hello All,

We are going through deployment to PROD and we found out around 1000+ emails which are queue to be sent to the respective recipients. We do not want the emails to be sent while running email history job.

 select distinct(emailtemplate) from emailhistory / select emailtemplate from emailhistory;

Is there any possible ways apart from Killing the Job, or removing the users or updating the sent status in the email history table.

Please advice.

Thanks,

Kundan Pathak

[Raghu]

@Kundan960  SMTP Box setting do error out and Email job remove the schedule.

still is issue , create the support ticket for email table handling

[rushikeshvartak]

Set status as 2 in emailhistoryprocess table