How To Make a Job In sql Server

Go To Sql serever 2008. For Creating a new job Go to Sql Server Agent and Job folder Right Click on that Click on New job

When You Will Click On New Job You Will Find A window Like-

 

Give The name of job and description of Job.Then Click On Steps Option on left Side Window

 

Click On New Button.You Will find This Window

Just Give Step name.Choose Database From Drop Down Write Your Querry In the command Multiline textbox or call sp From there and ckick on ok.After Clicking On Ok Just select Schedules option from left side you will find this window. click on new.

 

you will find this window

 

Just Set Time And day to run the Job.and click on ok.Your Job Is Completed