Re: [Emerald] SQL Agent?

Dale E. Reed Jr. ( (no email) )
Tue, 09 Nov 1999 16:21:40 -0800

David Routh wrote:
> Hello Dale,
> On a message posted around March of this year I saw that insttaks.sql
> should be run to install 5 tasks that are periodically run to maintain the
> Emerald database...
> I ran insttask.sql and the tasks seem to be there (I actually ran it twice
> because SQL ServerAgent wasn't running the first time I ran it)... In that
> message you also recommended changing the CheckDatabase task to checkdb.sql...
> To do this would I remove the "Step 1" in the task that says "Exec
> CheckDatabase" then "Open" checkdb.sql and make that "Step 1"... basically
> overwrite the "Exec Checkdatabase" that's in that task now?

What you should do is replace the contents of the CheckDatabase
stored procedure with the checkdb.sql script. Then you don't have
to change the task.


Dale E. Reed Jr. Emerald and RadiusNT__________________________________________IEA Software, Inc.

For more information about this list (including removal) go to: