SQL Server stored procedure run every day at the same time [duplicate]

This question already has answers here: Closed 10 years ago.

Possible Duplicate:

Scheduled run of stored procedure on SQL server

I have a stored procedure with the name transere_orders. I have to run it eve开发者_StackOverflow社区ry day at 22:00

How can I set scheduled tasks with SQL Server 2005

Thank you

---

Schedule it on SQL Server Agent.

ahh, here's an old question (you should'a searched for it first) Scheduled run of stored procedure on SQL server

oh well...

---

You have to add a job in Microsoft SQL Server Management Studio

after connecting to your server, Click on jobs category and then Add a new job,

scheduling it is ease as 1, 2, 3.