Post reply

Schedule job every six month

  • January 28, 2010 at 11:01 am

    #142019

    Is there a way to schedule SQL job every six month. I don't see any option when schedule a job. there is only daily,weekly and monthly.

  • January 28, 2010 at 11:08 am

    #1110248

    Take a close look at the frequency portion when you select Monthly.

    You can run it a job on a given day of every < number > months. If you set that to 6 it will run every 6 months on the selected day.

    Same thing, for example, if you want it to run on the first monday of every 6th month.

    Then you just have to decide when the schedule starts.

  • January 28, 2010 at 2:39 pm

    #1110371

    Yes, You are right..Thanks man..

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

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