3

How do I set up to run a stored procedure automatically every day in SQL Server 2008 R2?

hippietrail
  • 14,735
  • 16
  • 96
  • 147
Joshua
  • 2,185
  • 7
  • 37
  • 56

4 Answers4

4

Set up a SQL job http://msdn.microsoft.com/en-us/library/ms135739.aspx

Carth
  • 2,273
  • 1
  • 16
  • 26
2

You need to use the Job scheduler in the sql agent. Sql express doesn't include it so I just have a batch file run as a scheduled task to run it. -James

James Becwar
  • 1,181
  • 1
  • 10
  • 20
1

Was discussed here: Scheduled run of stored procedure on SQL server

Community
  • 1
  • 1
Andrey Marchuk
  • 12,987
  • 2
  • 32
  • 48
0

Under SQL agent you need to go to the job scheduler and create a job that runs the stored proc. Once you have created the job you can create one or more schedules for the job. http://msdn.microsoft.com/en-us/library/ms135739.aspx

Maess
  • 4,082
  • 19
  • 29