Export (0) Print
Expand All

Creating Jobs

SQL Server 2000

A job is a specified series of operations performed sequentially by SQL Server Agent. A job can perform a wide range of activities, including running Transact-SQL scripts, command line applications, and Microsoft® ActiveX® scripts. Jobs can be created to run tasks that are often repeated or schedulable, and they can automatically notify users of job status by generating alerts.

To create a job

Enterprise Manager

Transact-SQL

SQL-DMO

To give others ownership of a job

Enterprise Manager

Transact-SQL

SQL-DMO

Organizing Jobs

Microsoft SQL Server™ 2000 provides job categories to help you organize your jobs for easy filtering and grouping. For example, you can organize all your database backup jobs in the Database Maintenance category. You can also create your own job categories.

Multiserver categories exist only on a master server. There is only one default job category available only on a master server: [Uncategorized (Multi-Server)]. When a multiserver job is downloaded, its category is changed to Jobs from MSX at the target server.

To create a job category

Enterprise Manager

Transact-SQL

SQL-DMO

To delete a job category

Enterprise Manager

Transact-SQL

SQL-DMO

To assign a job to a job category

Enterprise Manager

Transact-SQL

SQL-DMO

To change the membership of a job category

Enterprise Manager

Transact-SQL

SQL-DMO

To list category information

Transact-SQL

SQL-DMO

Modifying Job Ownership

For security reasons, only the job owner or a member of the sysadmin role can change the definition of an existing job, start and stop the job, or give another user ownership of the job.

However, if you create a job that requires a drive letter or a universal naming convention (UNC) path, the job may run under your Microsoft Windows NT® 4.0 or Windows® 2000 user account while testing it. When SQL Server Agent then runs the job, it may not have the necessary permissions, drive letter configurations, or access to the required drive to execute the job. For more information, see Managing Security.

See Also

Creating Job Steps

Multiserver Administration

Scheduling Jobs

Running Jobs

Modifying and Viewing Jobs

Show:
© 2014 Microsoft