Sudantha
Sudantha

Reputation: 16224

How to: Schedule a Job (Stored Procedure / Trigger)

How to Schedule a Stored Procedure / Trigger in Microsoft SQL server ?

Upvotes: 2

Views: 5894

Answers (2)

anon
anon

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

Vinodharajan
Vinodharajan

Reputation: 79

You can set it up as a job under the SQL Server Agent from the Management console.

Upvotes: 3

Related Questions