In this tutorial post, we want to discuss about How to Create Job in SQL Server step by step. Before we get started, if you want to know about the Activation Serial key of SQL Server (all version), please go through the following article: Microsoft SQL Server All Versions Product Keys Collection. Follow the below steps to add or new job.

  1. First of all make sure that the SQL Server Agent is up and running. You can see it in the taskbar icon.
  2. After that if SQL Server Agent is not running, start it from the SQL Server Configuration Manger. You can also start the SQL Server Agent from the command prompt using the command netstart. The Command is as followed :

03. Connect to the database engine of SQL server using SQL Server Management Studio.

  1. In SQL Server Agent. You will see a Jobs folder over there. Right click on jobs and choose Add New
How to Create Job in SQL Server step by step

How to Create Job in SQL Server step by step

05. New Job popup will appear. Then specify the name of the job.

How to Create Job in SQL Server step by step

How to Create Job in SQL Server step by step

06. Cilck to next on the “Steps” in the left menu. A sql job can contain one or more steps. A step might be simply an sql statement or a stored procedure call. Add you step here

How to Create Job in SQL Server step by step

How to Create Job in SQL Server step by step

  1. Then add a new Job step
How to Create Job in SQL Server step by step

How to Create Job in SQL Server step by step

  1. Cilck to next 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 it self. You can specify recurring schedules also.
How to Create Job in SQL Server step by step

How to Create Job in SQL Server step by step

  1. Then add a new Job schedule
How to Create Job in SQL Server step by step

How to Create Job in SQL Server step by step

By the way, job is ready now. There are other thing you can use if needed like Alert, Notifications etc.

How to Create Job in SQL Server step by step

Leave a Comment