Email Notification

Question

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 :

 

I:

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