After it is complete, i will run the task installer, and I should be good to go..
Thanks for your help..
- Tim
---------- Original Message ----------------------------------
From: "Dale E. Reed Jr." <daler@iea-software.com>
Reply-To: emerald@iea-software.com
Date: Fri, 20 Aug 1999 11:01:04 -0700
>talon wrote:
>
> Ok, I checked the scheduled tasks.
> 1) Emerald Daily autmoated maitenance
> command:
> SQLMAINT.EXE -D Emerald -CkDBNoIdx -CkAlNoIdx -BkUpDB C:\MSSQL\BACKUP -BkUpMedia DISK -Rpt c:\mssql\log\emerald_maint.rpt
>
> 2) Emerald weekly autmoated maitenance
> command:
> SQLMAINT.EXE -D Emerald -UpdSts -Rpt c:\mssql\log\emerald_maint.rpt
>
> 3) Emerald autmoated maitenance
> command:
> SQLMAINT.EXE -D Emerald -CkDBNoIdx -CkAlNoIdx -UpdSts -BkUpDB C:\MSSQL\BACKUP -BkUpOnlyIfClean -BkUpMedia DISK -DelBkUps 4 -Rpt C:\MSSQL\LOG\Emerald_maint.rpt
>
> It appears I am missing the updatecalls task. What is the command I would use when setting up the update callstask?
There is a file, insttask.sql that comes with Emerald that installs the
following tasks:
/* Weekly: 12am Run a CheckDB Each Sunday morning */
/* Daily: 1am Delete Start records */
/* Daily: 2am Update the Calls Table, ServerID Field Once a night */
/* Daily: 3am Update the Calls Table, AccountID Field Once a night */
/* Daily: 1:45 am Trim Logs */
You can run the script in isql_w to isntall the tasks. The 2am/3am are
the
ones that update the calls table. Make sure you do a manual calls
update
before installing the tasks, if you have lots of calls that need to be
updated.
--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