How to Set SQL Server scheduled job

The following describes how to set an SQL proxy job:

If you need to regularly execute a stored procedure or SQL statements of less than 3200 characters in SQL Server, you can use management> SQL Server proxy> job.

1. Choose manage> SQL Server proxy> job (right-click)> create job

2. Create job attributes (General) -> name [customize the name of this job]-> the Enable box contains a check mark-> the default [unclassified (local)] can be selected or available in the Category field. -> the owner logs on to SQL Server by default. [Other Logon options are also available]-> description [fill in the detailed description of this job];

To create a job category, choose SQL Server proxy> job> right-click all tasks> Add, modify, and delete

3. Create a job property (STEP)-> New-> step name [custom Step 1 name]-> type [Transact-SQL (tsql) script]-> database [database to be operated]-> Command [if it is a simple SQL statement, write it directly. You can also open the button and enter a written *. SQL. To execute the stored procedure, enter exec p_procedure_name v_parameter1, [v_parameter2... V_parametern]-> OK (if there are multiple steps, you can call the new button below again; you can also insert, edit, or delete multiple existing steps );

4. Create job attributes (scheduling) -> Create scheduling-> name [custom scheduling name]-> enable the box with a check mark-> scheduling-> repeatedly appear-> change [scheduling schedule]-> OK (if you only need to save this job, if you do not do this regularly, you can remove the check mark in the enabled box );

5. Create job attributes (notifications)-> use the default notification method [write windows application system logs when a job fails]-> OK.

Some SQL Server knowledge related to job execution:

The SQL Server Agent service must run properly. The NT login user who starts it must be consistent with the NT login user who starts the SQL Server database;

Right-click a job to view the history of the job execution, or immediately start and stop the job.

Recently, when viewing the job history, we found that some jobs have many historical records and some have fewer historical records. How can I keep some jobs for a period of time according to their own needs? For example, keep a one-month history. I read the SQL Server online help documentation, which introduces:

Choose "manage"> "SQL Server proxy"> "right-click" properties ">" job system ">" limit the size of job history logs ".

The maximum size (number of rows) of job history logs. The default value is 1000. If a machine has a large number of jobs, you must increase the number of jobs. For example, if it is 100000, the maximum number of lines in each job's history log is 100 by default. If the job is executed twice a day and you need to keep the logs for one month, you can set it to 60. There is a mutual constraint between them, and we can change it according to our own needs.