Cheers
David Leigh
>Emerald 2.5 comes with a script named insttask.sql that contains five
>schduled tasks:
>
>1) Weekly Check Database
>2) Nightly Database Dump
>3) Nightly Log Cleanup
>4) Calls Update for Servers
>5) Calls Update for Accounts
>
>The first three are vital for maintaing your database, and just run
>three
>stored procedures that are also included in the instproc.sql script.
>Although
>the CheckDatabase proc only does a "DBCC CheckDB(Emerald", I would
>recommend
>replacing the proc with the checkdb.sql script that is much more
>comprehensive.
>
>The only other thing you should need to do is run the consolidation from
>the
>batch and peridically use the Admin to trim your calls table.
>
>--
>
>Dale E. Reed Jr. Emerald and RadiusNT
>__________________________________________
>IEA Software, Inc. www.iea-software.com
>
>
>
>For more information about this list, including removal,
>please see http://www.iea-software.com/maillist.html
>
For more information about this list, including removal,
please see http://www.iea-software.com/maillist.html