Date-based table purge

  • Comments posted to this topic are about the item Date-based table purge

  • Thanks for sharing your procedure - very interesting.

    One comment I have is that I noticed the parameters for the TableOwner (schema), and TableName are defined as varchar(64). Have you considered using the sysname type for these? This would be equivalent to a non-nullable nvarchar(128) type parameter.

  • Hi, thank you for the comment.

    I'm primarily an Oracle DBA so, there are kind of things like that I don't know. It's a good idea. I'll update it in a moment.

    By the way, if you are really interested, you could go and check what I've done of this with dbWarden history purge : I've made a view from which a SQL Job reads its informations to execute.

    The view could be transformed to a table ...

    Edit : Done 🙂

  • Thanks for the nice code.

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply