anand m

anand m

  • 1.4k
  • 339
  • 35k

Email Notification

Oct 23 2019 2:29 AM
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 

Answers (2)