scheduling stored procedure after every 30 min

Question

Post reply

scheduling stored procedure after every 30 min

scottichrosaviakosmos

SSCommitted

Points: 1889
More actions
August 29, 2010 at 5:37 am

#237482

i am using sql 2008 and i want to schedule a stored procedure . i want my sp to run after every 30 min and since i have one more sp which takes 20 min for execution completion so i want my 1st sp to run after completion of 2nd one.
how to schedule sp to execute after every 30 min and to schedule another sp to execute after the comppletion of 1st one.

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

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

WayneS SSC Guru Points: 95460 More actions · Answer 1

Triplicate post. Please post all responses at http://www.sqlservercentral.com/Forums/Topic977057-1292-1.aspx.

Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes

If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!

Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

ananthbhaskar Right there with Babe Points: 783 More actions · Answer 2

there is some clarity missing here,

1) do you want your sp1 to run only after the sp2 is completed:- for this you can schedule a job with two steps

Or

2) you want sp1 to run every 30 mins and want it to wait whenever sp2 is running :- for this there needs to another logic.