Skip to Content
author's profile photo Former Member
Former Member

Delete Messages from table SXMSPHIST.

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

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Sep 10, 2009 at 08:53 AM

    Hi,

    Refer SAP note 872388.

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

    Thanks

    Swarup

    Add a comment
    10|10000 characters needed characters exceeded

    • 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

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.