Creating new job in SQL Server Agent

We can create jobs in SQL server agent to execute SQL script or SSIS package or shell script etc. We can also automate that these and schedule this job to automatically runs.

Let’s learn how we will create a job in SQL Server Agent.

     

Expand the SQL Server Agent and right click on the Jobs and Click on the news job…

  

In the General tab, we need to give the job name and select Category. Here I am selecting my own custom category. In description, we will write a description of this job.

Read: Adding new (custom) SQL server job category

https://bageshkumarbagi-msbi.blogspot.com/2018/12/adding-new-custom-sql-server-job.html

Now go to the Steps tab

  

Click ok.

One step created.

  

Based on our requirement we can create n number of steps.

Now click ok.

A new job created successfully.

   

Let’s run this job.

Before running this job record in the table.

  

Now I am running this job.

For running this job Right click on this job and click on the start job.

Job will start

   

Completed successfully.

See the record in the table

  

A record is inserted successfully.