how to create a task to execute stored procedure acutomatically

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.