To do this, we need to open the SQL Server Management Studio from the Start Menu. You see a connection box where every field will be populated automatically, you have to click on Connect to continue.

To do this, we’ll use an SQL Server Agent Job. Using SQL Management Studio, create a new SQL Server Agent Job: Fill in the general details and then go to the Steps page to add a couple of steps.