Post reply

hi job maintanance

  • December 15, 2011 at 3:59 am

    #391135

    hi all

    I want set my job should run every 90 in sql server 2005 .how to set it and whether it is depending for service pack

    vivek

  • December 15, 2011 at 4:07 am

    #1421821

    please elaborate...

  • December 15, 2011 at 4:28 am

    #1421830

    Hi team

    I want execute my bakup job in every 90 in sql server 2005 .i tried chage the time in option like every occurens using ssms and it is not allow to add more 60 min .So please get that and also wherther it is depend on sp

  • December 15, 2011 at 4:54 am

    #1421844

    NM!

  • December 15, 2011 at 4:55 am

    #1421845

    It's not an elegant way of doing it, but you could schedule your job to run every 45 minutes starting at midnight, and include an initial step to check that the minute portion of the current date is either 00 or 30.

    John

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

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