Geeks With Blogs
Gaurav Taneja Great dreams... never even get out of the box. It takes an uncommon amount of guts to put your dreams on the line, to hold them up and say, "How good or how bad am I?" That's where courage comes in.

This is about adding a new SQL Jobs in the Sql Server 2005.

Step 1

Make sure that the SQL Server Agent is up and running. You can see it in the taskbar icon.

If SQL Server Agent is not running, start it from the SQL Server Configuration Manger

 

You can also start the SQL Server Agent from the command prompt using the command netstart

net start "SQL Server Agent (<instance name>)"
e.g net start "SQL Server Agent (SQLSERVER01)"

Step 2

Connect to the database engine of SQL server using SQL Server Management Studio.

 

Step 3

Expand the SQL Server Agent. You will see a Jobs folder over there. Right click on jobs and choose Add New.

 

Step 4

A New Job popup will appear. Specify the name of the job.

 

Step 5

Cilck next on the "Steps" in the left menu. A sql job can contain one or more steps. A step might be simply an sql statement or a stored procedure call. Add you step here

Job step added

 

Cilck next on the "Schedules" in the left menu. A sql job can contain one or more schedules. A schedule is basically the time at which sql job will run it self. You can specify recurring schedules also.

 

Job schedule added

 

You sql job is ready now. However there are other thing you can use if needed like Alert, Notifications etc.

Posted on Monday, January 10, 2011 7:02 PM SQL SERVER | Back to top


Comments on this post: Creating a new Job in Sql Step by Step

# re: Creating a new Job in Sql Step by Step
Requesting Gravatar...
A simple but very clear explanation . Good Work
Left by Guru on Nov 12, 2013 3:35 PM

Your comment:
 (will show your gravatar)


Copyright © Gaurav Taneja | Powered by: GeeksWithBlogs.net