How to create a job (Enterprise Manager)

To create a job

1. Expand a server group, and then expand a server.
   
   
2. Expand Management, and then expand SQL Server Agent.
   
   
3. Right-click Jobs, and then click New Job.
   
   
4. In the Name box, enter a name for the job.
   
   
5. Clear the Enabled check box if you do not want the job to be run immediately following its creation. For example, if you want to test a job before it is scheduled to run, disable the job.
   
   
6. Under Source, do one of the following:
   • Click Target local server if the job should run on this server only. Skip to Step 9 if you select this option.
     
     
   • Click Target multiple servers if the job should run on other servers. Then click Change.

     This option is enabled only if the server is a master server.

7. In the Change Job Target Servers dialog box, on the Available Servers tab, click a server, and then click the right arrow to move the server to the Selected target servers list.
   
   
8. Click OK to return to the New Job Properties dialog box.
   
   
9. In the Owner list, select a user to be the owner of the job.
   
   
10. In the Description box, enter a description of what the job does. The maximum number of characters is 512.

Important  Each job must have at least one step. A step must be created with the job before the job can be saved. For more information, see Creating Job Steps.