1. open the Sql server enterprise manager.
2. click on the management folder.
3. and select jobs.
4. right click on the jobs option and click new jobs.
5. type the name of the job.
6. select the category name (database name).
7. select the owner name.
8. type the description.
9. click on the step1 tab page.
10. and click on the new button.
11. write the step name like 'step1'.
12. select the type like 'Transact-sql script(TSQL)'.12. select the database name.
13. in command textbox type your uspname like exec usp_uspname.
14. click on the schedule tab page.
15. and click on the new schedule button.
16. type the name like 'abc'.
17. click on the recurring option button.
18. and click on the change button.
19. and click on the daily option button and also click on the occurs every option and select the time duration.
20. and after that click on the ok button.
