I need to execute a procedure at a spesific hour

Hello, i need some help on this...

I need to make a job that execute a procedure at 7 am , and other at 8 pm, can any one give a hand with this?

Regards

What version of SQL Server? If you are using a sku with agent, it does a great job and is pretty easy to set up.

If not, you might just consider using sqlcmd or isql and using the AT facility built into Windows. It is easy enough to do once you get the command you want to run.

|||Im working with SQL 2005|||Set up a SQL Agent Job to execute a Transact-SQL command to execute the stored procedure, and schedule it for when you want it to run.|||

open sql server management studio 2005

connect to your database server.

in the object explorer. click sql server agent.

right click jobs. then new jobs.

place your codes

|||Which version? Unless it is express, then Agent will be quite easy to set up (as long as whoever set up the server installed/enabled it.) Books online covers this pretty well, or some of the other posts outline the basics.