Post reply

I m using MS-SQL server 2005, and i want to schedule job on the interval of 15 day

  • May 11, 2013 at 8:08 am

    #293776

    Hi all,

    I m using MS-SQL server 2005, and i want to schedule job on the interval of 15 days, as in the MS-SQL server scheduler No option present to schedule the job on the interval of 15 days.

    Could any one give there view on the same.

    Thanks in advance.

  • May 11, 2013 at 8:14 am

    #1614383

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • May 11, 2013 at 10:05 am

    #1614386

    Hi just to correct mine wording. i need to schedule backup on the alternate Sunday.

  • May 11, 2013 at 10:33 am

    #1614389

    RRPA (5/11/2013)

    Hi just to correct mine wording. i need to schedule backup on the alternate Sunday.

    edit job schedule as per Gails post above

    frequency > weekly

    recurs every > 2

    tick "Sunday"

    does this help ?

    ________________________________________________________________
    you can lead a user to data....but you cannot make them think
    and remember....every day is a school day

  • May 11, 2013 at 10:47 am

    #1614390

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

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

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