Yes, I have verified that the Allow Overtime Check Box for the rate was NOT
checked and again that none of the TimeLeft fields are null.
Thanks,
TKT
----- Original Message -----
From: "Dale E. Reed Jr." <daler@iea-software.com>
To: <emerald@iea-software.com>
Sent: Thursday, March 02, 2000 11:32 AM
Subject: Re: [Emerald] Recurring time limits not working
> NCKCN wrote:
> >
> > I had set up the job described on the "How to setup Emerald to allow
limited
> > hours per month for a user" page at
> > http://www.iea-software.com/emerald/faqs/limited-time.html. The
procedure
> > was created and ran as scheduled, so SQL Agent is running fine. Time
banking
> > is enabled in RadiusNT. But no "TimeLeft" fields were updated or reset.
The
> > Job Scheduling Log says that it ran successfully the first of the month,
and
> > I also ran the job again manually several times but it still did not
reset
> > any of the "TimeLeft" fields in any account. I have no nulls in any of
the
> > "TimeLeft" fields. I also set all the "StandardHours" in the Rates table
to
> > not have any nulls even in the unmetered (unlimited) accounts. I really
> > don't want to have to go in every month and reset 3,000 "TimeLeft"
fields.
> > Below is the script that created the Proc and should have reset the time
> > limits from the site mentioned above. Any help would be greatly
appreciated.
>
> Did you verify that the Allow OverTime Check Box for the rate was NOT
> checked? The proc below only sets those users with a rate that does not
> allow over time (the overrefuse line). I believe there is a specific
> note about this as well.
>
> > Create Proc Update_TimeLeft AS
> > Update sa
> > Set sa.TimeLeft = (rt.StandardHours * rt.StandardInterval) / 60
> > From SubAccounts sa, AccountTypes at1, Rates rt
> > Where sa.AccountType = at1.AccountType
> > and at1.RateID = rt.RateID
> > and rt.OverRefuse = 1
> > and sa.Timeleft is NOT NULL
>
>
> Take one user and look at the criteria. There is not a lot of them.
> The two basic ones are the ALlow Overtime must not be checked and their
> timeleft field can not be NULL.
>
>
> --
>
> Dale E. Reed Jr. Emerald and RadiusNT
> __________________________________________
> IEA Software, Inc. www.iea-software.com
>
> For more information about this list (including removal) go to:
> http://www.iea-software.com/support/maillists/liststart
>
For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart