Re: [Emerald] SQL Agent?
David Routh ( drouth@davlin.net )
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
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.
>
OK, thanks... I'll have to work on that one.
David
>--
>
>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