SQL Server Create Job

If you have a job that needs to be performed automatically, such as how often or when each day is done, you can use the SQL Server job feature. Use the following steps:

1. Open SQL Server Configuration Manager

　　

2, found that SQL Server Agent can not be used, the first to open the Proxy service (if it is turned on, please ignore)

3, computer (right-click)-"Management-" service-"SQL Server Agent (MSSQLSERVER)-" Open, refresh SQL Server Configuration Manager, found that SQL Server Agent is enabled, you can use the job.

4. In SQL Server Configuration Manager, right-click Job-New job, named Classes_test here

　　

5, new job-"general

　

New job-"step-" new, click Confirm after adding, add the job successfully, and so on, you can add more than one step job.

　　

　　

New Job-plan (Add job execution time, which is set to execute every minute of the day)

　　

Click Confirm to add the execution job completion.

　　

Click Confirm to add the job successfully.

　　

SQL Server Create Job