Re: [Emerald] SQL Agent?

David Routh ( )
Tue, 09 Nov 1999 19:41:00 -0600

At 04:21 PM 11/9/1999 -0800, you wrote:
>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
>> 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.

OK, thanks... I'll have to work on that one.


>Dale E. Reed Jr. Emerald and RadiusNT
>IEA Software, Inc.
>For more information about this list (including removal) go to:

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