Scheduling SQL Jobs
The Job Details dialog contains specific information about the
scheduled. Job Agent uses this information to run the job against the
selected server instance. The SQL script box supports batch processes
utilizing the GO command. Furthermore, job names are unique to each
server and should therefore be named accordingly. Users can schedule a job to run
at the specified time daily, weekly, or monthly.
To schedule a job to run at midnight (12:00 AM), select 00 hours and
00 minutes.
Scheduling a Job
To schedule a job, right click on the job list and select New.
Alternatively you can select New from the Job menu.
Enter the following information in the Job Details dialog and click
Ok:
- Job: Enter job name and SQL code in the box under Job Name.
Job name cannot exceed 255 characters and cannot contain any special
characters {" # ' * / : ; < > ? \ |}. The SQL code box supports SQL
batches separated by the GO command (GO must be on a separate line).
- Schedule: Select the specific schedule of the job execution
time.
Daily: Executes the job on a daily basis at the specified
time.
Weekly: Executes the job once a week at the scheduled
time. M to S are the days of the week.
Monthly: Executes the job once a month on the specified
day of the month at the specified time.
|
