|
|
 |
Creating Jobs
|
A job is a specified series of operations performed sequentially by an SQL
Server Agent service located on the server. A single job can perform a
series of tasks including running Transact-SQL scripts and command line
applications. Jobs can be created to run tasks that are often repeated
or schedulable, and they can automatically notify users of job status by
email.
How to create a job
To create a job
- Right-click the jobs list and click New... or click
the New toolbar icon
 .
- In the Name box, enter a name for the job.
- Clear the Enabled check box if you do not want the
job to be runnable immediately following its creation. For example,
if you want to test a job before it is scheduled to run, disable
the job.
- In the Description box, enter a description of what
the job does. The maximum number of characters is 512.
- Select a Category for the job. Click the Browse
button (...) to setup your own job categories.
- Add at least one Job Step. Click
here
for more information.
- Optionally create a Job Schedule.
- Set any Notifications (email or event log) as
required.
- Click OK to save your job.
|
www.valesoftware.com
|
|
