Hi anirudhp,

Triggers are database operations which are automatically performed when an action such as Insert, Update or Delete is performed on a Table or a View in database.

Refer below articles for details.

Simple Insert Update and Delete Triggers in SQL Server with example

So when you want to execute the trigger to delete records from table?

You can use SQL Server Job Schedular to implement the task.

Automated Email Notifications using SQL Server Job Schedular