1

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 every day at 22:00

How can I set scheduled tasks with SQL Server 2005

Thank you

Community
  • 1
  • 1
Birby
  • 331
  • 1
  • 3
  • 8

2 Answers2

7

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...

Community
  • 1
  • 1
Alex
  • 14,338
  • 5
  • 41
  • 59
0

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.

Ken D
  • 5,880
  • 2
  • 36
  • 58