SQL Server定时调度.docxVIP

(1) Open Enterprise Manager, enter your server name in the management to start the SQL Server Agent. And then view the server properties, select the Automatically start SQL Server Agent.?????(2) Next, enter a job under the SQL Server Agent, choose New Job on the right point, right.?????(3) in the General, just enter a job classification to choose the last one database maintenance.?????(4) In the steps point New Steps, just enter the name of a step, the database selected into your database, you delete records, enter in the command statement, can also be Open to load the T-SQL script. Once youve got remember to analyze, there is no problem to continue. Advanced failed operation to go to the next step.????(5) in the Scheduling, point to New scheduling , just enter a scheduling point of Change , the frequency of selected daily happened on set 17:00:00, and then OK, and then click OK, then click OK, the configuration is complete.?????Original Source: /yuan0762/blog/item/25b1ad2bb37989f9e7cd404f.html???SQL Server: regular job settingSource: SANIf you need time to time or from time to time to execute a stored procedure or SQL statement in less than 3200 characters in SQL Server, can use the Management - SQL Server Agent - operations to achieve.1 Management - SQL Server Agent - job (click the right mouse button) - New Job?2, the New Job Properties (General) - name [the name of the custom of this assignment] - enabled box is a tick - Classification Service can choose the default available [Uncategorized (Local)] - The default login SQL Server users [also optional other login] - description [fill in the detailed description of content];To create a job classification: SQL Server Agent - Job - right click select All Tasks - Add, modify, delete?3, the New Job Properties (step) - New - Step customize the name of the first step] - type the Transact-SQL (TSQL) scripts] - database [the database] - command [If simple SQL to write directly into the can also be used to open the buttons