[Rodopi] No 'On Hold Late' on weekends

[Scott Collins]

Suspending NO plans over the weekend is exactly what I'm looking to do so it sounds like this should work.  I was primarily wanting to make sure that my simple edit would do that trick and that those plans that would normally have been suspended over the weekend would in fact get suspended on Monday.   I've thought about the issue of when the billing runs and Sat/Sun are the days I want to prevent suspension since billing runs just after the stroke of midnight (technically the beginning of the next day).  I don't want anyone to get suspended during a billing cycle when we have no accounting staff coming in later that morning.   Scott   -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Suneel Jhangiani Sent: Thursday, June 03, 2004 6:51 PM To: [EMAIL PROTECTED] Subject: [Rodopi] No 'On Hold Late' on weekends A very quick look at this suggests one inherent problem. As the procedure name does not have Radius in it, it suggests that this would affect all plans on not just Radius plans. A quick look at the Stored Procedure (via my http://www.rodopi-faq.com resource) proved that this would in fact affect all plans.   The actual select statement inside the stored procedure looks like it will delay suspension till Monday (take note of Cary’s advice due to billing time)., and is probably a better mechanism for you in that no plans would be suspended over the weekend.   If however, you still want this to be limited to dial-up or ‘Access’ only accounts (ie. Anything against Radius) you would need to modify the procedure to take into account Radius Profiles and which service plans require these.       ----- The trouble with doing something right the first time, is nobody appreciates how difficult it was.   (--------------------------------)         {(((((( (     Suneel Jhangiani           )        /_  _  ) (    Technical Director          )       ( .  .   ) ( Inter-Computer Technology Ltd. )        ( /   ) (----------------------------------oOOo------------oOOo----) ( 40 James Street                Tel: +44 (0) 20 7486 9601 ) ( London W1U 1EU                 Fax: +44 (0) 7050 678 978 ) ( United Kingdom               Email: [EMAIL PROTECTED]     ) (             Website: http://www.inctech.com              ) (----------------------------------------------------------) From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Scott Collins Sent: 03 June 2004 19:49 To: [EMAIL PROTECTED] Subject: [Rodopi] No 'On Hold Late' on weekends   We use Rodopi 5.2 sp3 and I have been passed the request to NOT put customers on hold for late payment on the weekends when our accounting staff is not available.  I believe I have found the stored procedure that puts the accounts on hold but I wanted to check with some of you Rodopi and SQL gurus to be sure I'm looking in the right place, as well as make sure this should work and not cause any additional problems.  Below are the first dozen or so lines of the SP along with my simple edit.  If I am correct, this should prevent the procedure from running on Saturday and Sunday and if I am reading the procedure correctly, any users who would have went on hold over the weekend will be found and put on hold when the procedure runs on Monday.  Anyone see any errors in my thinking? CREATE Procedure Maint_OnHoldLateSuspend         @CustomerID int = NULL,         @Proc int = 0 output As set nocount on if datename(dw, getdate()) IN ('Saturday', 'Sunday')         return 0 select @Proc= 0 declare @DateLateSuspCC smalldatetime,                 @DateLateSuspCheck smalldatetime,                 @DateLateSuspACH smalldatetime,                 @DateLateSuspCorpCheck smalldatetime,                 @BillingDate smalldatetime