archive delete

[Former Member]

Does anyone know how to delete the messages that are deleted when you run release and delete messages from the web link http://<hostname>:<port>/MessagingSystem/archiving/reorgdb.jsp

I have the archive/delete jobs running from SARA nightly but they don't seem to delete these messages.

I'd like to create a batch job that will do this if possible. Has anyone tried this or have any ideas on how to do this?

Thanks,

Lee

[Former Member]

Hello Lee,

If you can script an HTTP Get request you can execute an automated deletion by requesting a GET from the following two URLs:

Expiring the messages:

http://<host>:<port>/MessagingSystem/archiving/reorgdb.jsp?days=<days to keep>&expire

Deleting the expired messages:

http://<host>:<port>/MessagingSystem/archiving/reorgdb.jsp?days=<days to keep>&remove

You MUST expire the messages before deleting them, so allow plenty of time between executions of the two scripts (i'd recommend at least 15 minutes, perhaps more if you have a large number of stored messages). Execute the requests manually first, to get a good idea of how long each takes to complete before scripting the automation.

Thanks,

James Morgheim

[Former Member]

Your posts all point to using SARA for archive/delete. I currently have SARA configured to run archive/delete jobs for object BC_XMB as the archiving procedures state. This only has a minimal impact on reducing the size of my database. When I go to the link http://<my host>:<my port>/MessagingSystem/archiving/reorgdb.jsp I can release messages then delete them. This returns a lot of space to my database. These messages must be in a different object than BC_XMB. I want to archive/delete all these messages somehow without manually going to this web page and releasing them then deleting them. Can this be done with SARA and if so what objects should I choose to do this?

Lee

[Former Member]

HI Lee

Check whether SARA has all the tables for archiving and deleting the data.

Check this as well

Thanks

Gaurav

[Former Member]

Hi, Lee

.........>>archive delete

look at this link may help u and pls explain in breif .....

http://help.sap.com/saphelp_nw04/helpdata/en/be/f8fc3f37c2e569e10000000a155106/frameset.htm.

Regards,

Khan Azeez.

[Former Member]

Hello,

could you please give more information about the Query ..Actually I didnt get you.

With Regards,

Vidya

[Former Member]

Hi,

see this link..........

http://help.sap.com/saphelp_nw04/helpdata/en/72/c135406ee32e34e10000000a155106/frameset.htm