[Emerald] Recurring time limits not working

NCKCN ( (no email) )
Thu, 2 Mar 2000 09:51:20 -0600

Emerald Admin 2.05.0323
Emerald 2.05.0329
SQL 7.0

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.

Use Emerald

Create Proc Update_TimeLeft AS
Update sa
Set sa.TimeLeft = (rt.StandardHours * rt.StandardInterval) / 60