Is there a way to start a stored procedure at predefined intervals?

Question

I wanted the stored procedure to run at regular intervals every day. Is there a way to do the same on SQL Server 2005?

I know that we can create a batch file to run SP and schedule it with scheduled Windows tasks, but is there a way to do this from SQL Server itself?

Answer 1

There is a separate service called SQL Agent that is created for this specific purpose: scheduling tasks related to SQL Server.

This is a Windows service that is initially disabled, so you need to enable it. Otherwise, all this is very simple: Management Studio has a nice interface for managing the Agent.

Answer 2

You can create jobs with SQL Server 2005

Answer 3

Use SQL Agent to schedule jobs.

See Creating Jobs