Here is step by step guide of How to create and configure Scheduled job in SQL Server.

Open the Windows service Find the service with the name “SQL Server Agent (INSTANCE NAME)” Start SQL Agent Service Open Object Explorer in SSMS Creating First SQL Server Agent job Creating the New Job Defining Steps Defining the Job Step Schedule Defining New Job Schedule Viewing Execution History