Stored procedure in scheduler in SQL Server 2005

Question

Hi All,

I am using SQL Server 2005.

I have a stored procedure [say Sp_GetAllMaterialInfo], I want to put it in a scheduler that everyday this stored procedure execute on 2 P.M. daily. Please let me know the steps I have to follow to achieve in SQL Server 2005

Thanks in advance.

Answer 1

Create a sql server agent job.

Answer 2

How to schedule a job in SQL server:

http://technet.microsoft.com/en-us/library/ms191439.aspx

Answer 3

Or if you are using Express edition the approach here might help http://www.sqldbatips.com/showarticle.asp?ID=27 (Gives an example of how to run a procedure a as scheduled task)

Or a free utility to achieve the same thing as SQL Agent is here (I've not used it myself) http://www.lazycoding.com/products.aspx