Skip to main content
R
RajeshBalasunda1-Visitor
1-Visitor
September 20, 2012
Question

Delete Email Queue Entries through SQL

  • September 20, 2012
  • 1 reply
  • 744 views

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

1 reply

P
ptc-24720531-Visitor
1-Visitor
September 20, 2012

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

Terms & ConditionsAccessibility statement