CODEWITHSUNDEEP
sqlsql-server-2008stored-procedures
Joshua
Joshua

Reputation: 2295

How to run a stored procedure automatically every day

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

Upvotes: 3

Views: 30028

Answers (4)

Maess
Maess

Reputation: 4146

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

Upvotes: 0

Andrey Marchuk
Andrey Marchuk

Reputation: 13483

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

Upvotes: 1

James Becwar
James Becwar

Reputation: 1206

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

Upvotes: 2

Carth
Carth

Reputation: 2343

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

Upvotes: 4

Related Questions