Post reply

SQL Server Agent - Schedule job on last day of month

  • September 16, 2010 at 1:21 am

    #226890

    Hi all,

    Does anybody know what will happen if I schedule a job on the last day(31st) of every month through the Agent.

    Will SQL:

    Bypass a month which hasn't got 31 days or

    Will it default to the last day of the month.

    I have written a script and this can be accomadated via a daily schedule. SQL will automatically give you the last(i.e for jan 31,feb 28, march 31, etc)

    However I was wondering if the above can be done via the agent?

    tnx in advance.

  • September 16, 2010 at 1:26 am

    #1221952

    Got it thanks,

    there is an option for last day of every month:)

  • September 16, 2010 at 2:26 am

    #1221984

    Hi

    Visit following link for a good solution.

    http://www.sqldisco.com/?p=57

    Ali
    MCTS SQL Server2k8

  • January 31, 2019 at 7:26 pm

    #2020799

    Ali Tailor - Thursday, September 16, 2010 2:26 AM

    Hi Visit following link for a good solution.http://www.sqldisco.com/?p=57

    Unfortunately, link only answers tend to die, like this one.

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

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