I'm a noob 🙂 to SQL , so please don't judge me to harsh

When I deleted alerts, SQL server stays on 🙂 , can I send notification throw TSQL and not use alerts from SQL server Agent ?

Error Log :

Date,Source,Severity,Message

08/28/2014 09:50:24,,Warning,[396] An idle CPU condition has not been defined - OnIdle job schedules will have no effect

08/28/2014 09:50:24,,Warning,[260] Unable to start mail session.

08/28/2014 09:50:24,,Warning,[474] Unable to refresh Database Mail profile . (reason: No mail profile defined)

08/28/2014 09:50:23,,Information,[129] SQLSERVERAGENT starting under Windows NT service control

08/28/2014 09:50:23,,Error,[364] The Messenger service has not been started - NetSend notifications will not be sent

08/28/2014 09:50:13,,Information,[432] There are 12 subsystems in the subsystems cache

08/28/2014 09:50:13,,Information,[339] Local computer is FILM running Windows NT 6.1 (7601) Service Pack 1

08/28/2014 09:50:13,,Information,[310] 2 processor(s) and 3581 MB RAM detected

08/28/2014 09:50:13,,Information,[103] NetLib being used by driver is DBNETLIB; Local host server is

08/28/2014 09:50:13,,Information,[102] SQL Server ODBC driver version 11.00.2100

08/28/2014 09:50:13,,Information,[101] SQL Server FILM version 11.00.2100 (0 connection limit)

08/28/2014 09:50:13,,Information,[000]

08/28/2014 09:50:13,,Information,[495] The SQL Server Agent startup service account is NT Service\SQLSERVERAGENT.

08/28/2014 09:50:13,,Information,[100] Microsoft SQLServerAgent version 11.0.2100.60 (x86 unicode retail build) : Process ID 3792

08/28/2014 04:20:57,,Error,[LOG] Failed to send notification email to operator 'Evgeny' for alert 'FileAutogrowth'

08/28/2014 04:20:57,,Error,[441] SQLiMail API send mail failure (reason: System.NullReferenceException: In an instance of Object reference not set to an object.Microsoft.SqlServer.Management.SqlIMail.Server.Common.MailClient.SendMail(String strRecipientsToList<c/> String strRecipientsCcList<c/> String strSubject<c/> String strBodyText<c/> MessageType messageType<c/> MailPriority priority<c/> String sensitivity<c/> String fromAddress<c/> String replyTo)<nl/> ? Microsoft.SqlServer.Management.SqlIMail.Server.Common.MailClient.SendMail(String strRecipientsToList<c/> String strRecipientsCcList<c/> String strSubjec)

08/28/2014 04:20:46,,Error,[440] SQLiMail send mail failure (reason: )

08/28/2014 04:20:46,,Error,[298] SQLServer Error: 14607<c/> profile name is not valid [SQLSTATE 42000]

08/28/2014 04:20:25,,Warning,[396] An idle CPU condition has not been defined - OnIdle job schedules will have no effect

08/28/2014 04:20:25,,Warning,[260] Unable to start mail session.

08/28/2014 04:20:25,,Warning,[474] Unable to refresh Database Mail profile . (reason: No mail profile defined)

08/28/2014 04:20:25,,Information,[129] SQLSERVERAGENT starting under Windows NT service control

08/28/2014 04:20:24,,Error,[364] The Messenger service has not been started - NetSend notifications will not be sent

08/28/2014 04:20:14,,Information,[432] There are 12 subsystems in the subsystems cache

08/28/2014 04:20:13,,Information,[339] Local computer is FILM running Windows NT 6.1 (7601) Service Pack 1

08/28/2014 04:20:13,,Information,[310] 2 processor(s) and 3581 MB RAM detected

08/28/2014 04:20:13,,Information,[103] NetLib being used by driver is DBNETLIB; Local host server is

08/28/2014 04:20:13,,Information,[102] SQL Server ODBC driver version 11.00.2100

08/28/2014 04:20:13,,Information,[101] SQL Server FILM version 11.00.2100 (0 connection limit)

08/28/2014 04:20:13,,Information,[000]

08/28/2014 04:20:13,,Information,[495] The SQL Server Agent startup service account is NT Service\SQLSERVERAGENT.

08/28/2014 04:20:13,,Information,[100] Microsoft SQLServerAgent version 11.0.2100.60 (x86 unicode retail build) : Process ID 6924

so my guess is that a problem with Database Mail that i configure or May be some issues with security restriction

Thank you a lot Smit.