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.
First of all start SQL Server 2008 Management Studio.
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".
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".
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".
Now click on the "Schedules" tab and provide name, type, frequency and click "OK".
Now click on the alerts tab and click on the "Add" button and provide alert name, type, database name and click "Ok".
Now click on the notifications tab and select how you want notifications.
The final tab is the "Targets" tab that shows you the options of the target server, you can also select multiple target servers.