CODEWITHSUNDEEP
sql-serverperformancestored-proceduresscheduled-tasks
user1360733
user1360733

Reputation: 85

Schedule a stored procedure to run periodically?

I need to run a task to update a table, periodically, using a stored procedure. Could you let me know if it is possible to schedule periodic tasks and to run any system command within stored procedure?

Upvotes: 1

Views: 6759

Answers (2)

jabs
jabs

Reputation: 1848

I use a 3rd party tool for my schedules. To be honest, it's not a great deal better than Sql Server Agent, but there are few perks to it. It's called System Scheduler.

Upvotes: 0

Levi W
Levi W

Reputation: 815

You can use SQL Server Agent to create jobs that run at regularly-scheduled intervals. One of the job step types is executing a stored procedure.

Upvotes: 4

Related Questions