SQL Server2012 Create timed jobs-----illustrated to teach you to easily and quickly create

Original: SQL Server2012 Create timed jobs------illustrated to teach you to easily and quickly create

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

1, first we open SQL Server Agent, inside Select job

2. Right-click Job, select New Job

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

* * * need to note that the check is enabled to tick on. Category we are here by default and can be changed according to your needs.

4. Select Step, click New

5. Fill in the step name and the database you are running

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

Click on the analysis to make the picture frame like this.

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

7. Finally click OK to show the job we just created

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

9. OK to complete

SQL Server2012 Create timed jobs-----illustrated to teach you to easily and quickly create