Scheduling a query to be executed at given time in SQL Server 2005

Hi friend!

I want to schedule a query or procedure running at given time regularly eg: at 12AM daily. Please tell me how to do that in sql server 2005.

We use SQL server 2005 developer edition.

Thanks in advance.

SS2005 has a scheduller, SS Agent. Make sure it is installed and the service is up and running. You can get access to it through SSManagement Studio. BTW, this is a SSIS forum; if you have further question I will move this thread to a more appropiate forum.

Scheduling a query at regular intervals in sql server 2005

Hi friend!

I want to schedule a query or procedure running at regular intervals eg.@. 12AM on everyday. Please help me to do this in SQL server 2005

Thanks/Regards

Antony S

There are 3 choices I can think of off the top of my head;

1/ Use SQL Agent (not available in express) and create a T-SQL job.

2/ Use the windows task scheduler to call SQLCMD and then have it call a .sql file with your code in it.

3/ Use a service broker timer.

|||Books online reference http://msdn2.microsoft.com/en-us/library/ms191439.aspx|||Create a SQL Job and a schedule inside of the job to run everyday at 12am. Make sure that SQLAgent is enabled.sql