Learn more about Toad for SQL Server
at Dell Software

Find solutions and downloads at the
Toad for SQL Server Support Portal

Toad for SQL Server 6.6

Define Job Properties

This topic focuses on information that may be unfamiliar to you. It does not include all step and field descriptions.

To define properties for a job

  1. Select Jobs from the Agent node in the Object Explorer.

  2. Click .
  3. Complete the fields as necessary.  Review the following for additional information:

    Category

    Select a category (used to group jobs) for this job. The following categories are available:

    • Uncategorized (Local)—Groups jobs on the same SQL Server instance where the job is stored.

    • Database Maintenance—Groups general database maintenance actions.

    • Full-Text—Groups indexing actions for full text catalogs.  

    • Jobs from MSX—Groups jobs from a master server associated with a target server.

    • REPL-Alert Response—Groups predefined alert response jobs when a system is configured as a distributor.

    • REPL-Distribution—Groups jobs used to distribute data to users.

    • REPL-LogReader—Groups jobs used to run the Replication Log Reader Agent utility.

    • REPL-Merge—Groups jobs used to run the Replication Merge Agent utility.

    • REPL-QueueReader—Groups jobs used to run the Replication Queue Reader Agent utility.

    • REPL-Snapshot—Groups jobs used to run the Replication Snapshot Agent utility.

    • REPL-Subscription Cleanup—Groups jobs used to clean up metadata in the MSmerge_contents and MSmerge_tombstone system tables.

    • Web Assistant—Groups jobs used to update web pages automatically.

    • Uncategorized (Multi-Server)—Groups jobs that run on one or more servers.

    To view jobs currently assigned to the selected category, click .

 

Related Topics

Define Job Properties

Define Job Schedules

About Job Steps

Set Job Alerts

of