Log shiping Schedule works funky

• Kiryl Hakhovich

  Grasshopper

  Points: 12

  More actions

  May 12, 2006 at 8:29 am

  #113434

  Hey guys, thanks very much with your previous help on my backup issue. Works perfect now.

  However i ran into new problem I have had log shipping implemented and it worked fine till rescently i have tried to modify schedules. The job is scheduled as: Occurs every 1 days, every 15 minutes between 5:15 am and 11:45 pm.

  However when you look at the job history, it manages invoke itself at 3:15 am and then quiet till 5:15 am... and this messes up the logick in full-and-logs shipments.

  Now is there some garbage left somwhere and i can't see it (like old schedule info and etc?)

  PS. again it is MS SQL 2000 Standard ed.

• ARUL-285958

  Ten Centuries

  Points: 1081

  More actions

  May 14, 2006 at 11:44 am

  #637747

  Did u try to delete the job and recreate it as new one with the new schedule ???

  ---

  Get busy living ....or get busy dying....

• Kiryl Hakhovich

  Grasshopper

  Points: 12

  More actions

  May 15, 2006 at 8:26 am

  #637874

  Yep. tried deleting the schedule and recreating it. Same story.

  seems like some *old* schedule stuck somewhere. Is there a way to look at all scheduled jobs in a file? registry?

  thanks