Reputation: 16224
How to Schedule a Stored Procedure / Trigger in Microsoft SQL server ?
Upvotes: 2
Views: 5894
Reputation: 4618
Go to Management Studio > SQL Server Agent > Jobs > New > Enter a name and owner (usually sa) > Steps > New... > Choose your DB and type in your s.p. name.
From there, choose your schedule.
Upvotes: 3
Reputation: 79
You can set it up as a job under the SQL Server Agent from the Management console.
Upvotes: 3