In this article you will learn how to create a new job and schedule that job for execution in SQL Server 2008.
What is a SQL Job? A job is a specified series of actions that SQL Server Agent performs. Use jobs to define an administrative task that can be run one or more times and monitored for success or failure. A job can run on one local server or on multiple remote servers.
Getting Started
First of all start SQL Server 2008 Management Studio.
![Create-and-schedule-a-job-in-SQL-Server1.jpg]()
Image 1.
For this database I am going to create a job and schedule that job.
Now click on SQL Server agent and select "Jobs" and right-click and click on "New Job".
![Create-and-schedule-a-job-in-SQL-Server2.jpg]()
Image 2.
As you can see there are many steps, so let's go one by one. First provide a job name and description and click "OK".
General Tab:
![Create-and-schedule-a-job-in-SQL-Server3.jpg]()
Image 3.
Now click on "Next". The step name is Steps and provides a name, type and select database and write a command to save in a location and click "OK".
Steps Tab:
![Create-and-schedule-a-job-in-SQL-Server4.jpg]()
Image 4.
Now click on the "Schedules" tab and provide name, type, frequency and click "OK".
Schedules Tab:
![Create-and-schedule-a-job-in-SQL-Server5.jpg]()
Image 5.
Now click on the alerts tab and click on the "Add" button and provide alert name, type, database name and click "Ok".
Alerts Tab:
![Create-and-schedule-a-job-in-SQL-Server6.jpg]()
Image 6.
Now click on the notifications tab and select how you want notifications.
Notifications Tab:
![Create-and-schedule-a-job-in-SQL-Server7.jpg]()
Image 7.
The final tab is the "Targets" tab that shows you the options of the target server, you can also select multiple target servers.
Targets Tab:
![Create-and-schedule-a-job-in-SQL-Server8.jpg]()
Image 8.