automate dbcc/dump scripts

[unknown]

Hello!
I am not sure how to incorporate dbcc with dump scripts.
Also I need to receive email notification after the cronjob
is done. I would certainly appreciate if any body can share
some of the example. We are using Sun solaris ASE-15/Solaris
10
TIA

[Eugene Korolkov]

www.edbarlow.com

Post by unknown
Hello!
I am not sure how to incorporate dbcc with dump scripts.
Also I need to receive email notification after the cronjob
is done. I would certainly appreciate if any body can share
some of the example. We are using Sun solaris ASE-15/Solaris
10
TIA

[Cesare]

Very good information!

Cesare

"Eugene Korolkov" <***@davidsohn.com> ha scritto nel messaggio news:***@davidsohn.com...

www.edbarlow.com

AJ wrote:

Hello!
I am not sure how to incorporate dbcc with dump scripts.
Also I need to receive email notification after the cronjob
is done. I would certainly appreciate if any body can share
some of the example. We are using Sun solaris ASE-15/Solaris
10
TIA

I have done on Windows Platform using PowerBuilder tool to build custom Automated DBA Tasks

I unix we can also acheive same things

install dbccdb database

in unix write shell scripts to login to sybase server using isql
use dbcc checkstorage command
query for faults if any
if you find faults you can mail thru shell scripts itself or simple approach use xp_
automate update stats, sp_recompile and dump database tasks

For above tasks look at DBI: connect utilitites to connect and perform the operations.. You can look at Micheal Website for code snippets

Thanks
"Eugene Korolkov" <***@davidsohn.com> wrote in message news:***@davidsohn.com...
www.edbarlow.com
AJ wrote:

Hello!
I am not sure how to incorporate dbcc with dump scripts.
Also I need to receive email notification after the cronjob
is done. I would certainly appreciate if any body can share
some of the example. We are using Sun solaris ASE-15/Solaris
10
TIA