Job Job new process for SQL Service

First step: Open SQL Service to find jobs under SQL SERVER Agent

Note: If not found, check the version of the SQL service you installed through the SELECT @ @VERSION view

I install the version: Microsoft SQL Server 2014-12.0.4100.1 (X64)
APR 20 2015 17:29:27
Copyright (c) Microsoft Corporation
Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601:service Pack 1) (Hypervisor)

Step two: Stand-alone jobs, right-click New job (important signs must be ticked yes, otherwise the job does not run)

Name is the job title

Owner is the one who owns the job.

Category default selection [local]

Description describes the role of the job as I wrote, testing in order to insert a single piece of data into every minute of a table.

Finally, be sure to click the OK button. There's going to be this stuff under jobs.

Step Three: Right-click the property,

Choose 1 of steps,

Then click on the 2new button

Step name Steps to write

Type is selected

Database Select the databases you want to use

Command: If you are executing SQL directly, you can write it in.

If you are executing a stored procedure with the Exec stored procedure name parameter 1, parameter 2 ...

Then click on 3 Next appear as, all press as fill, last click 4OK

Fourth step: Set the schedule schedules, as

Click 2new to appear as

1 Name of the program

2 schedules type, I choose to repeat,

3 Set how long you want to execute, daily or monthly, or hourly, few seconds, start time and end time

4 finally don't forget OK, otherwise naught.

Click OK to appear as

In the end, we saw the job we set up.

Data as follows, insert a single piece of data every minute

Note: If you want to stop job, you can right-click, you can see the Stop job option, or the right-click Property, Enabled to remove the checkmark

Job Job new process for SQL Service