Post reply

How can I schdule a job to run yearly?

  • July 1, 2008 at 9:06 am

    #124484

    I was thinking adjusting the frequency to weekly and that wont work.

    Now I'm considering setting the start date to todays date (which is when I run the process), then the frequency to Monthly and setting it to run 1 every 12 months .

    It seems like that should work.

    Am I missing something simple?

    Thanks

  • July 1, 2008 at 9:11 am

    #836765

    In the schedule tab choose to run monthly and then select for example 'on the 1st day of every 12 months'

    You can then set it to run from which ever date you like.

  • July 1, 2008 at 9:33 am

    #836783

    thanks!

  • July 1, 2008 at 12:16 pm

    #836868

    Buxton69 (7/1/2008)

    In the schedule tab choose to run monthly and then select for example 'on the 1st day of every 12 months'

    You can then set it to run from which ever date you like.

    Good one.;) Never thought it that way. or I mostly get job schedules for weekly and monthly.

    SQL DBA.

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

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