Good day,
I need to archive old Catalog requests from my MDB. This is the query from the techdoc for archiving requests. It does nothing. Can anyone please help?
USE mdb
GO
DECLARE @return_value int
EXEC @return_value = [dbo].[usm_sp_archive_data]
@p_object_type = 'Request',
@p_date = '2017-03-31',
@p_bu = 'xxx Municipality'
SELECT 'Return Value' = @return_value
GO
-------------------------------------------