You can use tools like SQL Server Agent or Azure Automation to schedule and automate your data deletion tasks, and use alerts and notifications to inform you of any errors or failures.

Understanding SQL Server Agent SQL Server Agent is a popular tool from Microsoft for scheduling programs to run on Microsoft's SQL Server database platform.

For security, Microsoft has added the ability to run SQL Server Agent as a non-administrator and updated online documentation with more guidance for securing SQL Server.

Back Up Database - Performs database backups Execute SQL Server Agent Job – Starts a SQL Server Agent job Check Database Integrity – Runs DBCC CHECKDB to verify database integrity ...

In addition, SP3 includes patches for known vulnerabilities reported by users or discovered through testing, as well as the ability to run SQL Server Agent as a non-administrator.