Email Notification

anand m

6y806

Helllo All,

How to send email notification when Job mails in SQL server 2000, but SQL 2000 version there is no possibility to configure the Email notification , but current DB production server is sql 2000.

I am trying to configure the Email alerts when Job run from .bat(script) file .kindly help how i need to modify logic in this .bat file and below is my .bat script file in the attachment.

Script file :

cd Cen_jobs\legacy

copy I:\Cen_ftp\vega\Sharepoint\Sharepoint.txt Sharepoint.txt

copy I:\Cen_jobs\legacy\Sharepoint.txt I:\Cen_jobs\legacy\LastData\Sharepoint.txt

If Exist Sharepoint.txt goto Start

Goto EndJob

:Start

osql /S USFLMIAP-DB03 /U census_admin/P CA1934 /d patsdb /Q "truncate table Sharepoint"

bcp PatsDB.dbo.Sharepoint in Sharepoint.txt /S USFLMIAP-DB03 /Ucensus_admin /PCA1934 /f Sharepoint.fmt

:EndJob

Thanks

Anand

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

anand m6y ago
Hello team

I need to trigger email when this
bcp PatsDB.dbo.Sharepoint in Sharepoint.txt /S USFLMIAP-DB03 /Ucensus_admin /PCA1934 /f Sharepoint.fmt
command fails in the next line i need to check condition like if success its end but when bcp command fails
it send email notification to the group.

Help me this requirement.

Thanks
Anand
vijay nelson6y ago
I would suggest to write a powershell scripts to send email and invoke the script in your batch file. https://docs.microsoft.com/en-us/powershell/module/microsoft.powershell.utility/send-mailmessage?view=powershell-6