How delete messages from Database which are more than 1 month old

Hi Experts,

We are using PI 7.4 single stack and i want to delete messages which are older than 1 month.

I have configured "Message Retention" in NWA Administration. and background jobs also configured to archive and delete messages.

But it went wrong can any body help..