3

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

hippietrail
  • 15,848
  • 18
  • 99
  • 158
Joshua
  • 2,275
  • 7
  • 41
  • 57

4 Answers4

4

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

Carth
  • 2,303
  • 1
  • 17
  • 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,176
  • 2
  • 11
  • 20
1

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

Community
  • 1
  • 1
Andrey Marchuk
  • 13,301
  • 2
  • 36
  • 52
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,118
  • 20
  • 29