Post reply

scheduling stored procedure after every 30 min

  • August 29, 2010 at 5:38 am

    #228383

    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.

  • August 29, 2010 at 6:10 am

    #1213518

    Make a job. Make each sp a separate step.

    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

  • August 29, 2010 at 11:16 pm

    #1213606

    Wayne said it...Thats the way you can schedule the SP in Agent job and give the second SP as second step..

    If you dont have permission to run the job ask your DBA to do that for you

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

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