事件查看器查看mysql_数据库还原状态监控（查看事件查看器）

static void Main(string[] args)

{

SendMailAboutCheckServerStatus();

Console.ReadKey();

}

private static void SendMailAboutCheckServerStatus()

{

EventLog elog = new EventLog();

elog.Log = "Application";

string emailmessage = "";

for (int i = 0; i < elog.Entries.Count; i++)

{

try

{

if (elog.Entries[i].Source == "MSSQLSERVER")

{

DateTime starttime=Convert.ToDateTime( DateTime.Now.ToString("yyyy-MM-dd")+" 00:00:00");

DateTime endtime = Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd") + " 8:30:00");

if (elog.Entries[i].TimeGenerated > starttime && elog.Entries[i].TimeGenerated < endtime)

{

if (elog.Entries[i].EntryType.ToString() == "Error")

{

emailmessage  += "Message: " + elog.Entries[i].Message + "
" +

"App: " + elog.Entries[i].Source + "
" +

"Entry type: " + elog.Entries[i].EntryType + "
" +

"TimeGenerated :" + elog.Entries[i].TimeGenerated + "
";

}

if (elog.Entries[i].Message.Contains("数据库已还原"))

{

emailmessage += "Message: " + elog.Entries[i].Message + "
" +

"App: " + elog.Entries[i].Source + "
" +

"Entry type: " + elog.Entries[i].EntryType + "
" +

"TimeGenerated :" + elog.Entries[i].TimeGenerated + "
";

}

}

}

}

catch { }

}

SendEMailInfo(emailmessage);

Console.WriteLine("End!");

}

private static void SendEMailInfo(string emailmessage)

{

try

{

#region  邮件 Client设置

System.Net.Mail.SmtpClient client = new System.Net.Mail.SmtpClient();

client.Host = "mail.126.com";

client.UseDefaultCredentials = false;

client.Credentials = new System.Net.NetworkCredential("namn@126.com", "password");

client.DeliveryMethod = System.Net.Mail.SmtpDeliveryMethod.Network;

System.Net.Mail.MailMessage message = new System.Net.Mail.MailMessage();

message.From = new System.Net.Mail.MailAddress("name@126.com", "displayname", System.Text.Encoding.UTF8);

#endregion

message.Subject = "数据库还原状态";                  //邮件主题

message.Body = emailmessage;                         //邮件内容

message.To.Add("name@126.com");                      //收件人

message.BodyEncoding = System.Text.Encoding.UTF8;

message.IsBodyHtml = true;

message.Priority = System.Net.Mail.MailPriority.High;//邮件优先级

client.Send(message);

}

catch (Exception ex)

{

Console.WriteLine(ex.Message);

}

}