Delete Email Queue Entries through SQL

[RajeshBalasunda]

Hello,

We have some 800,000 entries in the email queue in one of our test environments. We had stopped the queue long time back and now we have to turn it on to test some capabilities. I tried deleting the entries from the Windchill shell using the command wt.queue.QueueManager. It doesnt delete them. It keeps restarting the MS. Is there a way to delete these entries through a SQL statement. We are using Windchill 9.1 M060.

Regards,

Rajesh Balasundaram

[ptc-2472053]

Rajesh,

You can use a query like this to clear the email queue entries (after backing up the schedulequeueentry table):

delete from schedulequeueentry where targetclass='wt.mail.EMailMessage';

Regards,

Ravi