These should get you pointed in the right direction.
Thanks for reply.
I read that docs, but i have not worked on SQL before so not able to develop query.
I am able to run below query,
declare @ret integer, @msg varchar(220)
exec REFRDEL_CLEANUP @ret output, @msg output
But as you know, bydefault KeepInterval is 5 days, i wanted to make it 90 days.
how to add that setting in above query?
When i tried to run below query i got syntex error.
Try exec settings_write_string '8d','database.cleanup.Refrdel','KeepInterval' ; without the (). Also make sure you have real single quotes -- some time pasting from HTML you get the backqoute.