Batch/command files and AT commands

[jwalker]

Hey List,
I've created a command file that copies my SQL disk backups to
another location and have created a new job with the at command to run the
command file. What I want to do now is have the command file e-mail me when
the file copy is finished and that it has completed successfully. Does
anyone know how to do this? Does anyone have an example of how to do this
in a command file? Thanks in advance,

B733 sp3.2 - SQL 7 sp2 - NT 4.0 sp6a

Justin Walker
OneWorld Systems Administrator
Colorado Christian University
303.963.3398
<mailto:[email protected]> [email protected]

 

[Guest]

Justin, you can add an SQL server job or step after the backup to copy the
file to another location. Then you could have SQL server e-mail, page or net
send the successful completion, failure... to you. I do this on another SQL
application where I copy the transaction log to a different server.

Thanks,

Crawford

 

[SSAJAROFF]

Hi Justin :

You may send mails from a SQL Server Agent job if a given task fails (or
succeeds).
Or... you may send mails with the xp_sendmail command (you need to have the
SQL Mail service on)

Yours, Sebastian

-----Mensaje original-----
De: jwalker [mailto:[email protected]]
Enviado el: Wednesday, February 28, 2001 3:27 PM
Para: [email protected]
Asunto: Batch/command files and AT commands


Hey List,
I've created a command file that copies my SQL disk backups to
another location and have created a new job with the at command to run the
command file. What I want to do now is have the command file e-mail me when
the file copy is finished and that it has completed successfully. Does
anyone know how to do this? Does anyone have an example of how to do this
in a command file? Thanks in advance,

B733 sp3.2 - SQL 7 sp2 - NT 4.0 sp6a

Justin Walker
OneWorld Systems Administrator
Colorado Christian University
303.963.3398
<mailto:[email protected]> [email protected]




--------------------------
To view this thread, visit the JDEList forum at:
http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat=0&Board=OW&Number=
6414
*************************************************************
This is the JDEList One World / XE Mailing List.
Archives and information on how to SUBSCRIBE, and
UNSUBSCRIBE can be found at http://www.JDELIST.com
*************************************************************