When setting up LiteSpeed Logshipping with script using 60 minute log intervals (MinuteInterval), it appears that the LiteSpeed cleanup stored procedures create jobs with double the interval as their scheduled run times.
The process works until the interval is 51 or greater. With intervals 60, rather than creating a schedule of 2 hours, the setup tried to create a schedule of "120 minutes".
The limitation is in Microsoft's SQL Management Studio whereby you cannot create a job with a schedule frequency of 60 minutes. And if you try to edit the schedule of such a job, you get the prompt error: Value of '120' is not valid for 'Value', 'Value' should be between 'Minimum' and 'Maximum'.
Parameter name: Value (System.Windows.Forms)
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center