Create and Schedule a Job in SQL Server 2008

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.