Home Forums SQL Server 2005 Administering How to notify when SQL Server Agent stopped automatically? RE: How to notify when SQL Server Agent stopped automatically?
Hemant.R
Ten Centuries
Points: 1286
More actions
December 11, 2012 at 11:52 pm
#1567712
hi,
you can create bat file which will send mail to you whenever sql server agent service get stopped.
go to run-->services.msc-->sql server agent service -->property-->recovery option
---->run program