Delete Messages from table SXMSPHIST.

[Former Member]

Hi Experts,

I need to delete the messages from SXMSPHIST table.

I have scheduled the jobs but the table size is still growing.

Following is the output of program RSXMB_SHOW_STATUS

Message Status

==============

Message Status: 001 Number: 0

Message Status: 002 Number: 0

Message Status: 003 Number: 92.219

Message Status: 004 Number: 0

Message Status: 005 Number: 0

Message Status: 006 Number: 0

Message Status: 007 Number: 0

Message Status: 008 Number: 0

Message Status: 009 Number: 0

Message Status: 010 Number: 6.493

Message Status: 011 Number: 0

Message Status: 012 Number: 64.694

Message Status: 013 Number: 0

Message Status: 014 Number: 4.474

Message Status: 015 Number: 0

Message Status: 016 Number: 0

Message Status: 017 Number: 0

Message Status: 018 Number: 0

Message Status: 019 Number: 0

Message Status: 020 Number: 0

Message Status: 021 Number: 408

Message Status: 022 Number: 0

Message Status: 023 Number: 7.140

Message Status: 024 Number: 0

Message Status: 025 Number: 0

Message Status: 026 Number: 0

Message Status: 027 Number: 0

Message Status: 028 Number: 0

Message Status: 029 Number: 578.409

Message Status: 030 Number: 0

Message Status: 030 Number: 0

How do I delete the messages in message status 029.

Regards

Milan

[Former Member]

Hi,

Refer SAP note 872388.

This will help you to delete/archive the XMl messages.

Thanks

Swarup

[Former Member]

Hi Swarup,

I have seen this note....

The messages that are successfully processed are getting deleted also.

I want to know how to delete the message with Status 029 because that has the most entries and it is being added daily.

Regards

Milan