Implementing Jobs

Using SQL Server Agent jobs, you can automate administrative tasks and run them on a recurring basis. You can run a job manually or schedule it to run in response to schedules and alerts.

This illustration shows the job execution and job step processing that occurs when a job is run by SQL Server Agent.

Jobs can be written to run on the local instance of Microsoft® SQL Server™ or on multiple servers. To run jobs on multiple servers, you must set up at least one master server and one or more target servers.

Anyone can create a job, but a job can be edited only by its owner or members of the sysadmin role.