Creating Jobs
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
Transact-SQLTo give others ownership of a job
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
To delete a job category
To assign a job to a job category
To change the membership of a job category
To list category information
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.