• Yes.

    You can script it out and run the script every hour with SQL Server Agent, or you can create a maintenance task.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP