MS SQL Basics Tutorial: SQL jobs

A job is defined as a multi-step task, each of which is a possible Transact-SQL statement that represents a task. A job is a typical planning task and an automated task. Database backup and recovery, data replication, data import/export, and so on can be defined as jobs, which are then completed by the SQL Server Agent at the planned time.

The execution steps for creating a job are:

(1) Start SQL Server Enterprise Manager, log on to the specified server, click Management in sequence, and then "+" on the left side of the SQL Server Agent (if the SQL Server Agent is not started please start)

(2) Right-click the Jobs icon, select the new job option in the pop-up menu, and open the New Job Properties dialog box, as shown in Figure 17-8.

In the dialog box, set the properties of the job by selecting a different tab page. Each job includes the following properties: Name, Category, Owner, Description, Job steps, schedules, notifications.

(3) The General tab defines the name, Category, Owner, and Description properties of the job, each of which has the following meanings: Name: Refers to the job, the job name on the same server must be unique, its maximum length is 128 characters; Category: Represents the job directory, which can be grouped into the same job directory for those with certain commonalities; Owner: Represents the owner of the job, and the sysadmin role user can change the owner of the job; Description: Represents a description of the job, with a maximum length of 512 a character; Last modified: Indicates when the job was first modified, if the newly created job is notapplicable; Enabled: Indicates that the job is valid, otherwise it must be started manually; Source: Used to show which server the job was created on; Target Local server: Indicates that the job is running on localhost, (4) Select the Steps tab, and then click the New button to open the New Job Steps dialog box as shown in Figure 17-9, the meanings of the options in the General tab are as follows:

See the full set of "MS SQL Basics Tutorials"