Monitoring Disk Space and Sending Alerts with TSQL

• jullietl

  SSC Journeyman

  Points: 75

  More actions

  September 25, 2007 at 9:11 am

  #736063

  Bob,

  We have a similar requirement to monitor mount points I would like to look at how you have used chkdisk and parsed the results. My email id is jullietl@yahoo.com.

  thanks

• gbgykkcci00000-r

  Mr or Mrs. 500

  Points: 547

  More actions

  October 1, 2007 at 7:51 pm

  #737956

  I am new to SQL2005. I received the following error when execute the SP

  (3 row(s) affected)

  Msg 15281, Level 16, State 1, Procedure xp_sendmail, Line 1

  SQL Server blocked access to procedure 'sys.xp_sendmail' of component 'SQL Mail XPs' because this component is turned off as part of the security configuration for this server. A system administrator can enable the use of 'SQL Mail XPs' by using sp_configure. For more information about enabling 'SQL Mail XPs', see "Surface Area Configuration" in SQL Server Books Online.

  Msg 15281, Level 16, State 1, Procedure xp_sendmail, Line 1

  SQL Server blocked access to procedure 'sys.xp_sendmail' of component 'SQL Mail XPs' because this component is turned off as part of the security configuration for this server. A system administrator can enable the use of 'SQL Mail XPs' by using sp_configure. For more information about enabling 'SQL Mail XPs', see "Surface Area Configuration" in SQL Server Books Online.

  I check on the Help inside the SQL2005 and it warn us not to use the SQL_Mail but use the Database Mail instead and I have successfully configurated the SMTP database Mail. However, how can I change the SP to use the Database Mail instead of the SQL sendMail

  Thanks

• gbgykkcci00000-r

  Mr or Mrs. 500

  Points: 547

  More actions

  October 1, 2007 at 7:53 pm

  #737957

  I am new to SQL2005. I received the following error when execute the SP

  (3 row(s) affected)

  -- Msg 15281, Level 16, State 1, Procedure xp_sendmail, Line 1

  -- SQL Server blocked access to procedure 'sys.xp_sendmail' of component 'SQL Mail XPs' because this --- component is turned off as part of the security configuration for this server. A system administrator --- can enable the use of 'SQL Mail XPs' by using sp_configure. For more information about --- --

  -- enabling 'SQL -- Mail XPs', see "Surface Area Configuration" in SQL Server Books Online.

  -- Msg 15281, Level 16, State 1, Procedure xp_sendmail, Line 1

  -- SQL Server blocked access to procedure 'sys.xp_sendmail' of component 'SQL Mail XPs' because this -

  -- component is turned off as part of the security configuration for this server. A system administrator -

  -- can enable the use of 'SQL Mail XPs' by using sp_configure. For more information about --

  -- ng 'SQL -- l XPs', see "Surface Area Configuration" in SQL Server Books Online.

  I check on the Help inside the SQL2005 and it warn us not to use the SQL_Mail but use the Database Mail instead and I have successfully configurated the SMTP database Mail. However, how can I change the SP to use the Database Mail instead of the SQL sendMail

  Thanks

• gbgykkcci00000-r

  Mr or Mrs. 500

  Points: 547

  More actions

  October 1, 2007 at 7:53 pm

  #737958

  I am new to SQL2005. I received the following error when execute the SP

  (3 row(s) affected)

  -- Msg 15281, Level 16, State 1, Procedure xp_sendmail, Line 1

  -- SQL Server blocked access to procedure 'sys.xp_sendmail' of component 'SQL Mail XPs' because this --- component is turned off as part of the security configuration for this server. A system administrator --- can enable the use of 'SQL Mail XPs' by using sp_configure. For more information about --- --

  -- enabling 'SQL -- Mail XPs', see "Surface Area Configuration" in SQL Server Books Online.

  -- Msg 15281, Level 16, State 1, Procedure xp_sendmail, Line 1

  -- SQL Server blocked access to procedure 'sys.xp_sendmail' of component 'SQL Mail XPs' because this -

  -- component is turned off as part of the security configuration for this server. A system administrator -

  -- can enable the use of 'SQL Mail XPs' by using sp_configure. For more information about --

  -- ng 'SQL -- l XPs', see "Surface Area Configuration" in SQL Server Books Online

  .

  I check on the Help inside the SQL2005 and it warn us not to use the SQL_Mail but use the Database Mail instead and I have successfully configurated the SMTP database Mail. However, how can I change the SP to use the Database Mail instead of the SQL sendMail

  Thanks

• gbgykkcci00000-r

  Mr or Mrs. 500

  Points: 547

  More actions

  October 1, 2007 at 7:53 pm

  #737959

  I am new to SQL2005. I received the following error when execute the SP

  (3 row(s) affected)

  -- Msg 15281, Level 16, State 1, Procedure xp_sendmail, Line 1

  -- SQL Server blocked access to procedure 'sys.xp_sendmail' of component 'SQL Mail XPs' because this --- component is turned off as part of the security configuration for this server. A system administrator --- can enable the use of 'SQL Mail XPs' by using sp_configure. For more information about --- --

  -- enabling 'SQL -- Mail XPs', see "Surface Area Configuration" in SQL Server Books Online.

  -- Msg 15281, Level 16, State 1, Procedure xp_sendmail, Line 1

  -- SQL Server blocked access to procedure 'sys.xp_sendmail' of component 'SQL Mail XPs' because this -

  -- component is turned off as part of the security configuration for this server. A system administrator -

  -- can enable the use of 'SQL Mail XPs' by using sp_configure. For more information about --

  -- ng 'SQL -- l XPs', see "Surface Area Configuration" in SQL Server Books Online

  .

  I check on the Help inside the SQL2005 and it warn us not to use the SQL_Mail but use the Database Mail instead and I have successfully configurated the SMTP database Mail. However, how can I change the SP to use the Database Mail instead of the SQL sendMail

  Thanks

• gbgykkcci00000-r

  Mr or Mrs. 500

  Points: 547

  More actions

  October 1, 2007 at 7:54 pm

  #737960

  I am new to SQL2005. I received the following error when execute the SP

  -- Msg 15281, Level 16, State 1, Procedure xp_sendmail, Line 1

  -- SQL Server blocked access to procedure 'ys.xp_sendmail' of component 'SQL Mail XPs' because this -

  -- component is turned off as part of the security configuration for this server. A system administrator -

  I check on the Help inside the SQL2005 and it warn us not to use the SQL_Mail but use the Database Mail instead and I have successfully configurated the SMTP database Mail. However, how can I change the SP to use the Database Mail instead of the SQL sendMail

  Thanks

• gbgykkcci00000-r

  Mr or Mrs. 500

  Points: 547

  More actions

  October 1, 2007 at 7:54 pm

  #737961

  I am new to SQL2005. I received the following error when execute the SP

  -- Msg 15281, Level 16, State 1, Procedure !!!!x!!!!p_sendmail, Line 1

  -- SQL Server blocked access to procedure '!!!!y!!!!s.xp_sendmail' of component 'SQL Mail XPs' because this -

  -- component is turned off as part of the security configuration for this server. A system administrator -

  I check on the Help inside the SQL2005 and it warn us not to use the SQL_Mail but use the Database Mail instead and I have successfully configurated the SMTP database Mail. However, how can I change the SP to use the Database Mail instead of the SQL sendMail

  Thanks

• gbgykkcci00000-r

  Mr or Mrs. 500

  Points: 547

  More actions

  October 1, 2007 at 7:54 pm

  #737962

  I am new to SQL2005. I received the following error when execute the SP

  I check on the Help inside the SQL2005 and it warn us not to use the SQL_Mail but use the Database Mail instead and I have successfully configurated the SMTP database Mail. However, how can I change the SP to use the Database Mail instead of the SQL sendMail

  Thanks

• gbgykkcci00000-r

  Mr or Mrs. 500

  Points: 547

  More actions

  October 1, 2007 at 7:55 pm

  #737963

  I am new to SQL2005. I received the following error when execute the SP

  I check on the Help inside the SQL2005 and it warn us not to use the SQL_Mail but use the Database Mail instead and I have successfully configurated the SMTP database Mail. However, how can I change the SP to use the Database Mail instead of the SQL sendMail

  Thanks

• gbgykkcci00000-r

  Mr or Mrs. 500

  Points: 547

  More actions

  October 1, 2007 at 7:56 pm

  #737964

  I am new to SQL2005. I received the following error when execute the SP

  I check on the Help inside the SQL2005 and it warn us not to use the SQL_Mail but use the Database Mail instead and I have successfully configurated the SMTP database Mail. However, how can I change the SP to use the Database Mail instead of the SQL sendMail

  Thanks

• gbgykkcci00000-r

  Mr or Mrs. 500

  Points: 547

  More actions

  October 1, 2007 at 7:57 pm

  #737965

  I am new to SQL2005. I received the following error when execute the SP

  I check on the Help inside the SQL2005 and it warn us not to use the SQL_Mail but use the Database Mail instead and I have successfully configurated the SMTP database Mail. However, how can I change the SP to use the Database Mail instead of the SQL sendMail

  Thanks

• dt293

  Default port

  Points: 1412

  More actions

  November 5, 2007 at 6:01 am

  #748198

  For anyone else who needs to modify the script to use SQL 2005 dbmail just change (assuming db mail is correctly set up already)....

  EXEC master..xp_sendmail @recipients = 'email@domain.com',

  @subject = @MailSubject,

  @message = @AlertMessage

  to

  EXEC msdb..sp_send_dbmail @recipients = 'email@domain.com',

  @subject = @MailSubject,

  @body = @AlertMessage

• DBA-640728

  SSChampion

  Points: 12898

  More actions

  April 1, 2008 at 2:25 pm

  #796853

  hello, thank you for your script, question how can i run with my other servers?

• DBA-640728

  SSChampion

  Points: 12898

  More actions

  April 14, 2008 at 9:35 am

  #802135

  hi how can i edit this sp so i get also the percentage? and modify the alert if i have less than 10%? :crying:

• daniel-471430

  SSC Journeyman

  Points: 76

  More actions

  April 17, 2008 at 4:48 am

  #803573

  I've read the helpful comments here.

  i am using it in a similar way.

  but how can i read the sizes of mount points?

  thanks for your help!

  cheers

  daniel