We have a logshipping setup, where the
LS_Restore job on the secondary database is switched off every night for the datawarehouse to grab its data. The restore cycle is set to 15 minutes and if
LS_Restore would kick in, the datawarehouse connection would get severed - the interface therefore switches off
LS_Restore. When the datawarehouse interface is done, the
LS_Restore job is turned back on.
However, this window can be longer than one hour (by just ten minutes or there-abouts), and this then triggers the
LS_Alert job to raise errors.
How can we extend the range on
LS_Alert to, say, 1,5 hours?