[Emerald] SQL Agent?

David Routh ( drouth@davlin.net )
Tue, 09 Nov 1999 17:14:05 -0600

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?

Thanks for your help.

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