SQL Server 2012 Create timed Jobs (illustrated, teach you to easily create quickly) _mssql

How does SQL Server2012 create timed jobs? Interested can look at, illustrated Oh!

1, first we open the SQL Server Agent, which selects the job

2, right key job, select New Job

3, fill in some corresponding content, name and description can be filled in.

Note that you have enabled this tick to be checked on. Categories we can do this by default and make changes according to your requirements.

4, select the steps, click New

5, fill in the name of the step and the database running

Note that the command line is to execute your stored procedure directly to write exec .... Can

Click on the analysis out of such a frame on the picture can be

6, click on the plan to edit the number of times you want to perform the time interval is good.

7, the final click to determine will be shown
The assignment we just set up

8, to see if the execution is correct, the Mail select job Start step

9,
OK complete