Post reply

modifying stored procedure

  • May 13, 2003 at 12:41 pm

    #81614

    I have a stored procedure and it's scheduled to run for every 15 mins.And its working fine.But now I want to modify my stored procedure.If i modify the stored procedure it it going to run as per the old schedule or should I reschedule it?

    Thanks.

  • May 13, 2003 at 12:43 pm

    #457016

    Are you talking about a SQL Job or a stored procedure? If you change a stored procedure that is run by a SQL Agent job, then the job will run the updated proc; no need to "reschedule" the job.

  • May 13, 2003 at 12:52 pm

    #457020

    Thanks for the info.

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

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