how to execute task automataically in sql server

Schedule a Job in SQL

The SQL Server Agent job is the specified action or series of actions that the SQL Server Agent will execute at any specific date time.