You can automate administrative tasks using SQL Server Agent jobs. You define the job one time, yet you can run it many times. You can run a job manually or schedule it to run in response to schedules and alerts. This topic explains the tasks you need complete to implement a job.
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 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.