-If we want to execute any procedural code automatically on specific time either once or repeatedly then we can create a Scheduled job for that code.

-Following are the steps to create a Scheduled Job.

1. Connect to your database of SQL server in SQL Server Management Studio.

2. On the SQL Server Agent. There you will find a Jobs folder. Right click on jobs and choose Add New.

3. A New Job window will appear. Give a related name for the job.

4. Click next on the "Steps" in the left menu. A SQL job can have multiple steps either in the form of SQL statement or a stored procedure call.

5. Click on the "Schedules" in the left menu. A SQL job can contain one or more schedules. A schedule is basically the time at which sql job will run itself. You can specify recurring schedules also.

-Using scheduled job you can also create alert and notifications.