Community Tip - Did you get called away in the middle of writing a post? Don't worry you can find your unfinished post later in the Drafts section of your profile page. X
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
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