Set time to Call Store Procedure

Question

Set time to Call Store Procedure

Thongchai

Newbie

Points: 1
More actions
November 24, 2004 at 2:51 am

#87069

How can i set time to calling store procedure?

Thank you...

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Frank Kalis SSC Guru Points: 111183 More actions · Answer 1

Create a job that executes the SP. You can schedule this as you need.

--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

Steve Jones - SSC Editor SSC Guru Points: 740606 More actions · Answer 2

Keep in mind you're limited to starting on the minute, so seconds involved and the job are not reentrant. If it's already running, it will not run again.