Job Scheduler Tutorial - PowerPoint PPT Presentation

Loading...

PPT – Job Scheduler Tutorial PowerPoint presentation | free to download - id: 48969d-MGY1Y



Loading


The Adobe Flash plugin is needed to view this content

Get the plugin now

View by Category
About This Presentation
Title:

Job Scheduler Tutorial

Description:

Job Scheduler Tutorial Job Scheduler Automated Database Administration Marion Morrison & Sourabh Tripathi Start Tutorial Content Tutorial Content (cont.) Overview Job ... – PowerPoint PPT presentation

Number of Views:180
Avg rating:3.0/5.0
Slides: 118
Provided by: Sybas1
Category:

less

Write a Comment
User Comments (0)
Transcript and Presenter's Notes

Title: Job Scheduler Tutorial


1
Job Scheduler Tutorial
Job Scheduler Automated Database Administration
Marion Morrison Sourabh Tripathi
Start
2
Tutorial Content
Schedules
Overview
Definitions
Create a Schedule
Usage
Modify a Schedule
Architecture
Delete a Schedule
Security Roles
Jobs
Scheduled Jobs
Create a Scheduled Job from a Job
Create a Job
Modify a Job
Create a Scheduled Job from Scratch
Delete a Job
Modify a Scheduled Job
Execute a Scheduled Job
Disable a Scheduled Job
Enable a Scheduled Job
Delete a Scheduled Job
Next
Prev
3
Tutorial Content (cont.)
Templates
Templates
Job History
Job History
Current JS Templates
Purge History
Create a Job from a Template
Job Output
JS Administration
Configure Job Scheduler
Configure sybmgmtdb
Next
Prev
4
Overview
  • Job Scheduler is
  • an ASE feature beginning with release 12.5.1.
  • a central component of Sybases self-management
    and resource. tuning initiative and is designed
    to meet the needs of its growing self-management
    infrastructure.
  • Job Scheduler enables
  • database administrators to perform database
    maintenance and routine tasks with minimal human
    intervention.
  • users to create and schedule jobs, mix and match
    them and share them with other users.

Next
Prev
Back to Start
5
Definitions
  • Job Definition of the specific work to be
    performed.
  • Currently all jobs are SQL.
  • A job is generic until it is scheduled.
  • Schedule A definition of when a job is to be
    executed.
  • May be repeating or non-repeating.
  • Supports date and time constraints.
  • A schedule is generic until attached with a job.
  • Scheduled Job Any job bound to any schedule.
  • A job may be bound to multiple schedules.
  • A schedule may be bound to multiple jobs.
  • Only scheduled jobs are executable.

Next
Prev
Back to Start
6
Definitions (cont.)
  • What we mean when we say
  • Job Scheduler Server The ASE where Job
    Scheduler is installed and running.
  • Target Server The ASE where a scheduled job is
    run.
  • JS Task An ASE internal task that determines
    when scheduled jobs should run and notifies the
    JS Agent to run them.
  • JS Agent An external process that gets the job
    information from the sybmgmtdb and connects to
    the target server and issues the job commands.
  • sybmgmtdb The database that stores all the job,
    schedule, and scheduled job information,
    including job output and history.

Next
Prev
Back to Start
7
Usage
  • Primary goal of Job Scheduler is to facilitate
    automation of routine DBA tasks, particularly
    those that tune and manage an Adpative Server.
  • User Activities in Job Scheduler
  • Create, modify and delete jobs.
  • Create, modify and delete schedules.
  • Create, modify and delete scheduled jobs.
  • Administer scheduled jobs.
  • Execute immediately through run_now.
  • Enable/Disable a scheduled job.
  • View history and output of each execution.
  • Administer Job Scheduler.

Next
Prev
Back to Start
8
Security Roles
  • Job Scheduler adds new roles to ASE to prevent
    inappropriate access, modification and deletion
    of jobs, schedules, scheduled jobs, and job
    history and output data.
  • js_user_role.
  • Create and manage their own jobs and schedules.
  • Run their own or shared scheduled jobs.
  • js_admin_role.
  • Everything js_user_role can do.
  • Manage other users jobs, schedules and scheduled
    jobs.
  • Perform Job Scheduler administrative tasks.

Next
Prev
Back to Start
9
Architecture
ASE Plugin Job Scheduler windows
Job Scheduler Server
Target Server
ASE
JS Agent
ASE
job info
JS Task
job id
job, schedule, admin data
scheduled job info
scheduled job info
sybmgmtdb
Job Scheduler stored procedures
Next
Prev
Back to Start
10
Getting Started
  • Most JS activities can be accomplished from
    either the graphical user interface or from the
    stored procedures that come with the Job
    Scheduler.
  • In the next sections of the tutorial, we will
    create a job and a schedule and then bind the two
    to create a scheduled job.
  • We start at the Job Scheduler folder in the ASE
    Plugin.

Next
Prev
Back to Start
11
ASE Plugin
Click here to display JS content
Next
Prev
Back to Start
12
Role Differences
  • Only Users with js_admin_role can view all jobs,
    schedules and scheduled jobs.
  • Next couple of slide show the admin role using
    jobs as an example.

This user has no jobs of his own, but
has js_admin_role.
Next
Prev
Back to Start
13
Viewing All
  • Right-click on Jobs folder.

Next
Prev
Back to Start
14
Viewing All (cont.)
  • Click on the Show jobs for all users option.

This is a toggle option to turn it off, just
click on it again
Next
Prev
Back to Start
15
Create a Job
  • To use the job wizard
  • Click on Scheduled Jobs folder.
  • Click on Jobs folder.
  • Double click on Add Job.

Next
Prev
Back to Start
16
Create a Job (cont.)
  • Enter the name of your job.
  • A job is an ASE object so its name must follow
    the same identifier rules as other ASE objects.

Next
Prev
Back to Start
17
Create a Job (cont.)
  • Enter a description for your job.
  • This should help you and others understand what
    your job does.
  • Ignore the Templates box for now they are
    covered in another section.

Next
Prev
Back to Start
18
Create a Job (cont.)
  • Enter the T-SQL that makes up your job.
  • You can use the SQL editor to create and edit
    your SQL.
  • You can also load your SQL from a file or paste
    it into the Job Definition box.

Next
Prev
Back to Start
19
Create a Job (cont.)
  • Now its time to set some job properties, like
  • Can there be multiple executions at the same
    time?
  • Can others use your job to create a scheduled
    job?
  • Should a scheduled job created from this job run
    as you or as the person who created the scheduled
    job?

Next
Prev
Back to Start
20
Create a Job (cont.)
  • This property adds a check to prevent runaway
    jobs that may not finish or terminate properly.
    It is inherited by all scheduled jobs that are
    created from this job.
  • This is the maximum amount of time the job should
    be allowed to run.

Next
Prev
Back to Start
21
Create a Job (cont.)
  • Prior to completing your job, review the job
    summary for correctness. Use the Back button to
    go back and make any corrections.
  • If all is well, click Finish to create your job.

Next
Prev
Back to Start
22
Create a Job (cont.)
  • New job shows up in the Jobs folder.
  • Pertinent details of the job are shown for a
    quick survey of existing jobs.

Congratulations, job created!
Next
Prev
Back to Start
23
Modify a Job
  • Find your job in the Jobs folder and right-click
    directly over it.
  • Select the Properties menu item.

Next
Prev
Back to Start
24
Modify a Job (cont.)
  • The Properties window allows you to modify most
    job properties.

Only users with js_admin_role can change the job
owner.
Next
Prev
Back to Start
25
Modify a Job (cont.)
  • We can modify the T-SQL as needed.

Next
Prev
Back to Start
26
Modify a Job (cont.)
  • We changed this job to be shared and to always
    run as the owner (jsuser) and changed the amount
    of time the job can run.
  • Click OK to save the changes.

Next
Prev
Back to Start
27
Modify a Job (cont.)
Congratulations, job modified!
Next
Prev
Back to Start
28
Delete a Job
  • Owners can delete their own jobs, but users with
    js_admin_role can delete the jobs of other users.
  • Find the job in the Jobs folder and right-click
    directly over it.
  • Select the Delete menu item.

Tip you can select multiple jobs for
deletion by holding down the shift key while
clicking on job names.
Next
Prev
Back to Start
29
Delete a Job (cont.)
  • Confirm the deletion.

Next
Prev
Back to Start
30
Delete a Job (cont.)
  • Note a job associated with a schedule can not be
    deleted, until all scheduled jobs using it are
    deleted.

Congratulations, job deleted!
Next
Prev
Back to Start
31
Create a Schedule
  • To use the Add Schedule wizard
  • Click on Scheduled Jobs folder.
  • Click on Schedules folder.
  • Double-click on Add Schedule.

Next
Prev
Back to Start
32
Create a Schedule (cont.)
  • Enter the name of your schedule.
  • A schedule is an ASE object so its name must
    follow the same identifier rules as other ASE
    objects.

Next
Prev
Back to Start
33
Create a Schedule (cont.)
  • Enter a description for your schedule.
  • This should help you remember more about your
    schedule.
  • This is where you can also choose to share your
    schedule with others.

Next
Prev
Back to Start
34
Create a Schedule (cont.)
  • Specify a time range.
  • You can specify a start time for the schedule or
    a time range for repeating schedules by choosing
    the Between option.

Next
Prev
Back to Start
35
Create a Schedule (cont.)
  • TIME OUT
  • The server time can be displayed as a 12-hour or
    24-hour clock. This is a Windows server
    configuration (control panel-gtregion
    options-gttime tab).
  • The Start and Between time values must be stated
    in a 24-hour clock for now (look for a more
    flexibility in the future).
  • The Between start time means that on days when
    your repeating scheduled job runs, this is the
    time frame during which it will run.
  • For non-repeating jobs that select the Between
    option, only the beginning time is used.

Next
Prev
Back to Start
36
Create a Schedule (cont.)
  • Now its time to select a start date.
  • Use the calendar drop-down list to find the
    correct month and year. Then click on the
    desired date.
  • Alternatively, you can modify the date in the
    first textfield.
  • The default date is the current date.

Next
Prev
Back to Start
37
Create a Schedule (cont.)
  • Now its time to select an end date, for example
  • We choose no end date, i.e., jobs using this
    schedule will be scheduled to run indefinitely.
  • Uncheck the No end date to select a end date
    and create limited schedule.

Next
Prev
Back to Start
38
Create a Schedule (cont.)
  • Now its time to specify recurrence of the
    schedule
  • Schedules can repeat every N minutes, N hours or
    N days.
  • Schedules can be restricted to certain days of
    the week or month (not valid with repeat interval
    of days. ).

Next
Prev
Back to Start
39
Create a Schedule (cont.)
  • A schedule can be limited to specific days of the
    week.

Next
Prev
Back to Start
40
Create a Schedule (cont.)
  • A schedule can be limited to specific days of the
    month.
  • Notice the Last day of the month option. Dont
    get caught off guard selecting the 29, 30 or 31
    when you really mean the last day of the month.

Next
Prev
Back to Start
41
Create a Schedule (cont.)
  • Prior to completing your schedule, review the
    schedule summary for correctness. Use the Back
    button to go back to make any corrections.
  • If all is well, click on Finish to create your
    schedule.

Next
Prev
Back to Start
42
Create a Schedule (cont.)
  • New schedule shows up in the Schedules folder.
  • Pertinent details of the schedule are shown for a
    quick survey.

Congratulations, schedule created!
Next
Prev
Back to Start
43
Modify a Schedule
  • Find your schedule in the Schedules folder and
    right-click directly over it.
  • Select the Properties menu item.

Next
Prev
Back to Start
44
Modify a Schedule (cont.)
  • The Properties window allows you to modify
    schedule properties.

Only users with js_admin_role can change the
schedule owner.
Next
Prev
Back to Start
45
Modify a Schedule (cont.)
  • We can modify the description, time-range and
    sharing options from here if needed.

Next
Prev
Back to Start
46
Modify a Schedule (cont.)
  • We can modify the start and end dates from here,
    if needed.

Next
Prev
Back to Start
47
Modify a Schedule (cont.)
  • We can modify the recurrence options from here,
    if needed.

Next
Prev
Back to Start
48
Modify a Schedule (cont.)
Congratulations, schedule modified!
Next
Prev
Back to Start
49
Delete a Schedule
  • Owners can delete their own schedules, but users
    with js_admin_role can delete the schedules of
    other users.
  • Find the schedule in the Schedules folder and
    right-click over it.
  • Select the Delete menu item.

Next
Prev
Back to Start
50
Delete a Schedule (cont.)
  • Confirm the deletion.

Next
Prev
Back to Start
51
Delete a Schedule (cont.)
  • Schedule deleted.
  • Like jobs, schedules cannot be deleted while in
    use by a scheduled job.

Congratulations, schedule deleted!
Next
Prev
Back to Start
52
Scheduled Jobs
  • Using existing jobs and schedules only a few
    steps are required to bind the two and create a
    scheduled job. A scheduled job is the concrete
    object that is truly run-able as it is composed
    of the job to be completed, the time to do the
    job, and the server on which to execute the job.
  • There are two ways to create a scheduled job
  • Associate a schedule with an existing job.
  • Select the job.
  • Select the schedule.
  • Specify the server on which the job will to run.
  • Use the scheduled job wizard.
  • Create a new job.
  • Select an existing schedule or create a new
    schedule.
  • Specify the server on which the job will to run.

Next
Prev
Back to Start
53
Create a Scheduled Job from a Job
  • Select the job and right click on it.
  • Select Schedule menu item.

Next
Prev
Back to Start
54
Create a Scheduled Job (cont.)
  • Job Scheduler Wizard
  • Confirm this is the Job you want to schedule.

Next
Prev
Back to Start
55
Create a Scheduled Job (cont.)
  • Choose a schedule for running your job from the
    list provided.
  • If the schedule doesnt exist, go create the
    schedule and then return to the Schedule Job
    wizard.

Next
Prev
Back to Start
56
Create a Scheduled Job (cont.)
  • Next, choose a target ASE where you want your job
    to execute.

Next
Prev
Back to Start
57
Create a Scheduled Job (cont.)
  • Heres your chance to override the selected jobs
    timeout property.
  • You can also turn off logging for each execution
    of this scheduled job.

Next
Prev
Back to Start
58
Create a Scheduled Job (cont.)
  • Select post execution options
  • Disable scheduled job on failure.
  • Delete scheduled job after schedule is exhausted.

Next
Prev
Back to Start
59
Create a Scheduled Job (cont.)
  • Prior to completing your scheduled job, review
    the scheduled job summary for correctness. Use
    the Back button to go back and make any
    corrections.
  • If all is well, click on Finish to create your
    scheduled job.

Next
Prev
Back to Start
60
Create a Scheduled Job (cont.)
  • Click on the Scheduled Jobs folder to see the
    newly created schedule job.

Congratulations, scheduled job created!
Next
Prev
Back to Start
61
Create a Scheduled Job from Scratch
  • Click on the Scheduled Jobs folder (the top Job
    Scheduler folder).
  • Double-click on Add Scheduled Jobs.

Next
Prev
Back to Start
62
Create a Scheduled Job (cont.)
  • We need to create a job, and here we give our job
    a name.

Next
Prev
Back to Start
63
Create a Scheduled Job (cont.)
  • Now choose an existing schedule or create a new
    one.
  • If you create a new schedule, the wizard will
    prompt you for all the schedule information, but
    first

Next
Prev
Back to Start
64
Create a Scheduled Job (cont.)
  • Enter the job information.
  • This page should look familiar.
  • Looks a lot like the Add Job wizard. Refer to
    the Create a Job section for a review as we skip
    over the prompts for job properties.

Next
Prev
Back to Start
65
Create a Scheduled Job (cont.)
  • Enter the schedule information.
  • Again, this page should look familiar.
  • Looks a lot like the Add Schedule wizard. Refer
    to the Create a Schedule section for a review as
    we skip over the prompts for schedule properties.

Next
Prev
Back to Start
66
Create a Scheduled Job (cont.)
  • With the job and schedule information entered,
    its time to enter the scheduled job information.
  • Select the ASE that will run the job.

Next
Prev
Back to Start
67
Create a Scheduled Job (cont.)
  • Heres your chance to override the selected jobs
    timeout property.
  • You can also turn off logging for each execution
    of this scheduled job.

Next
Prev
Back to Start
68
Create a Scheduled Job (cont.)
  • Select post execution options
  • Disable scheduled job on failure.
  • Delete scheduled job after schedule is exhausted.

Next
Prev
Back to Start
69
Create a Scheduled Job (cont.)
  • Prior to completing your scheduled job, review
    the summary for correctness.
  • Use the Back button to go back and make any
    corrections.
  • If all is well, click on Finish to create your
    scheduled job.

Next
Prev
Back to Start
70
Create a Scheduled Job (cont.)
  • More Summary information.

Next
Prev
Back to Start
71
Create a Scheduled Job (cont.)
  • New scheduled job shows up in the Scheduled Jobs
    folder.
  • Pertinent details of the scheduled jobs are shown.

Congratulations, scheduled job created!
Next
Prev
Back to Start
72
Modify a Scheduled Job
  • Find your scheduled job in the Scheduled Job
    folder and right-click directly over its ID.
  • Select the Properties menu item.

Next
Prev
Back to Start
73
Modify a Scheduled Job (cont.)
  • Edit the desired properties in the Properties
    window.

Only users with js_admin_role can change the
scheduled job owner.
Next
Prev
Back to Start
74
Modify a Scheduled Job (cont.)
  • On the Parameters tab changes can be made to
  • The target ASE.
  • Execution options.
  • Post execution options.

Next
Prev
Back to Start
75
Execute a Scheduled Job
  • Scheduled jobs execute automatically according to
    the associated schedule.
  • To run a job immediately, right-click on the
    scheduled job and click on run now.

Next
Prev
Back to Start
76
Disable a Scheduled Job
  • You can prevent a scheduled job from being run
    according to its schedule by disabling it.
  • Right-click on the scheduled job and click on the
    Disable menu item.

Next
Prev
Back to Start
77
Enable a Scheduled Job
  • To make a disabled scheduled job run-able again,
    enable it.
  • Right-click on the scheduled job and click on the
    Enable menu item.
  • The scheduled job will run at its next appointed
    time.

Next
Prev
Back to Start
78
Delete a Scheduled Job
  • Right-click on the scheduled job and select the
    delete menu item.
  • Note Deleting a scheduled job does not delete
    its components. The job and schedule still exist.

Next
Prev
Back to Start
79
Delete a Scheduled Job (cont.)
  • Confirm the deletion.

Next
Prev
Back to Start
80
Delete a Scheduled Job (cont.)
Congratulations, scheduled job deleted!
Next
Prev
Back to Start
81
Job History
  • Job history is kept for each execution of each
    scheduled job.
  • Pertinent details of each execution are displayed
    in the Job History folder.

Next
Prev
Back to Start
82
Job History (cont.)
  • View job history properties by selecting the
    Properties menu item.
  • These properties are read-only.

Next
Prev
Back to Start
83
Job History (cont.)
  • More job execution information.

Indicates current state of a job, such as queued,
running, terminated.
Indicates how the job exited success (1),
failure (2), etc
An error code you can set for your job.
ASE _at__at_error value
Operating system code
You can set short and long messages in your job
and have them displayed here.
Next
Prev
Back to Start
84
Job History (cont.)
  • You can delete job history records by
    right-clicking on the history item.

Next
Prev
Back to Start
85
Purge History
  • You purge history data using the purge tool.
  • Double-click on the Purge History item.

Next
Prev
Back to Start
86
Purge History (cont.)
  • Specify the purging criteria.
  • Records must match all criteria.
  • Can choose to see how many records will be purged.

Next
Prev
Back to Start
87
Purge History (cont.)
  • Provide values for purge criteria.

Next
Prev
Back to Start
88
Purge History (cont.)
  • Review how many records will be purged.
  • Click Finish to complete the purge or go back to
    change purge criteria or values.

Next
Prev
Back to Start
89
Job Output
  • Job output is the output ISQL would print to the
    screen when it executes the same TSQL, such as
  • Print statements.
  • Error messages.
  • Informative messages from executed commands like
    DUMP DATABASE.
  • Each time a scheduled job is executed, the job
    output is stored in sybmgmtdb.
  • To view job output
  • Click on the Job History folder.
  • Right-click over the ID field of the desired
    execution scheduled job.
  • Click on the View Log menu item.

Next
Prev
Back to Start
90
Job Output (cont.)
Next
Prev
Back to Start
91
Job Output (cont.)
  • Sample job output.

Next
Prev
Back to Start
92
JS Administration
  • Only users with js_admin_role can access and make
    changes.
  • Access the Administrative window by
    right-clicking on Scheduled Jobs folder.

Next
Prev
Back to Start
93
JS Administration (cont.)
  • Configuring the Job Scheduler
  • JS Task
  • Start at boot time.
  • Start or stop now.
  • Set interval for checking for scheduled jobs that
    need to run.
  • Set maximum number of jobs JS Task is allowed to
    send to JS Agent concurrently.
  • Default maximum is 32, but may be set as high as
    640, per cfg_options.
  • Some platforms may have more restrictive
    limitations within their native threading POSIX
    library.
  • Set maximum size of job output.
  • Sybmgmtdb
  • Set the percentage of total database space
    allotted to
  • Job output.
  • Job history.
  • Free space.

Next
Prev
Back to Start
94
Configure JS Task
Next
Prev
Back to Start
95
Configure sybmgmtdb
Next
Prev
Back to Start
96
Templates
  • Included with Job Scheduler are templates that
    can be used to create jobs for several database
    management and self-tuning tasks.
  • Template play an important role in ASE
    self-management because the provide a short cut
    to creating customized jobs.
  • Each template packages Transact SQL (T-SQL) that
    performs a specific database tuning or
    maintenance task. Sybase-provided templates save
    DBAs the work of creating their own TSQL, UNIX
    CRON or operating system-level scripts.

Next
Prev
Back to Start
97
Templates (cont.)
  • The templates provided with Job Scheduler address
    such common DBA activities as
  • Database backups.
  • Transaction log dumps.
  • Update and deletion of statistics.
  • Reorganizing table and indexes and reclaiming
    wasted space.
  • Configuration of ASE environment parameters
    Number of locks, Number of user connections,
    Metadata cache.
  • Templates can be selected as the basis for
    creating a job in the Job Wizard.

Next
Prev
Back to Start
98
Templates (cont.)
  • When the you create a job from a template, the
    wizard will prompt you for values needed by the
    job at run time.
  • When the job is created, the TSQL is constructed
    and ready for execution.
  • You can add your own TSQL to that created from
    the template.

Next
Prev
Back to Start
99
Current Sybase Templates
  • Backups
  • Sybase Backup Database to Disk Template
  • Sybase Backup Transaction Log to Disk Template
  • Statistics Management
  • Sybase Delete Statistics Template
  • Sybase Update Statistics Template
  • Reorganization
  • Sybase Rebuild Index Template
  • Sybase Rebuild Tables Template
  • Sybase Reclaim Index Space Template
  • Sybase Reclaim Table Space Template
  • Reconfiguration
  • Sybase Reconfigure Locks Template
  • Sybase Reconfigure Metadata Cache Template
  • Sybase Reconfigure User Connection Template

Next
Prev
Back to Start
100
Create a Job from a Template
  • Start by clicking on the Add Job item in the Jobs
    folder.
  • Enter the job name as before.

Next
Prev
Back to Start
101
Create a Job from a Template (cont.)
  • Click on the Browse button to select a template.

Next
Prev
Back to Start
102
Create a Job from a Template (cont.)
  • Templates are grouped according to functionality.
  • Select one and click OK.

Next
Prev
Back to Start
103
Create a Job from a Template (cont.)
  • The wizard provides template information
  • name this will not change for the life of the
    template.
  • version an X.0 number indicates a major
    release, while X.X indicates a bug fix or minor
    change.
  • creator currently only Sybase is distributing
    templates.
  • ID the database record identifier.
  • Note the template ID is unique to each install
    of the templates. It depends upon the order in
    which templates are inserted into the database
    and may change if a template is deleted and
    reinserted.

Next
Prev
Back to Start
104
Create a Job from a Template (cont.)
  • Enter the values needed by the template to create
    the job.
  • A description is provided for each parameter.
  • Where possible, default values are provided.

Next
Prev
Back to Start
105
Create a Job from a Template (cont.)
  • In our example, we need to enter a dump location.

Next
Prev
Back to Start
106
Create a Job from a Template (cont.)
  • Do we want the server name included in the dump
    filename?

Next
Prev
Back to Start
107
Create a Job from a Template (cont.)
  • Do we want the date and time included in the dump
    filename?

Next
Prev
Back to Start
108
Create a Job from a Template (cont.)
  • How many stripes do we want?
  • Note in version 1.0 of the Backup Database to
    Disk Template, you can not specify multiple
    stripe devices, i.e., all stripes go to the same
    dump location.

Next
Prev
Back to Start
109
Create a Job from a Template (cont.)
  • Select the Compression level.

Next
Prev
Back to Start
110
Create a Job from a Template (cont.)
  • Review the TSQL summary.
  • Nows your chance to go back and fix any
    mistakes.
  • Click Finish to return to the Add Job wizard.

Next
Prev
Back to Start
111
Create a Job from a Template (cont.)
  • More Template summary.

Next
Prev
Back to Start
112
Create a Job from a Template (cont.)
  • End of Template summary.

Next
Prev
Back to Start
113
Create a Job from a Template (cont.)
  • Add a description for the job and continue on in
    the Add Job wizard.

Next
Prev
Back to Start
114
Create a Job from a Template (cont.)
  • Heres another chance to modify the job TSQL.
  • Change values provided in the Template wizard.
  • Add your own TSQL.

Next
Prev
Back to Start
115
Create a Job from a Template (cont.)
  • Skipping ahead, we see the Job summary.

This shows the template used to create this Job.
Next
Prev
Back to Start
116
Create a Job from a Template (cont.)
  • Job created from the template shows up in the
    Jobs folder.

Congratulations, Job created!
Prev
Next
Back to Start
117
Thank You
  • Thank you for using the Job Scheduler Tutorial.
  • Check back later for updates as new functionality
    is added to the Job Scheduler.
  • If you have comments or suggestions, please email
    them to JS Tutorial.

Prev
Back to Start
About PowerShow.com