SQLism

Logging and Blogging SQL Server Experiences.

Showing posts with label Send an Alert. Show all posts
Showing posts with label Send an Alert. Show all posts

Friday, August 23, 2013

Send an Alert thru email on number of User Connections

IF (SELECT cntr_value FROM sys.dm_os_performance_counters WHERE counter_name='User Connections')>0
EXEC msdb.dbo.sp_send_dbmail
@profile_name = 'MyProfile',
@recipients = 'Mymai@MyMailcorp.com',
--@body = @bodyText,
@body_format = 'TEXT',
@subject = 'Testing Email' ;
Posted by SQLism at 10:33 AM No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Labels: email, number of User Connections, Send an Alert
Older Posts Home
Subscribe to: Posts (Atom)

Blog Archive

  • ▼  2020 (6)
    • ▼  July (1)
      • Reorganize all indexes in a Database in SQL Server.
    • ►  March (1)
    • ►  February (4)
  • ►  2018 (3)
    • ►  August (3)
  • ►  2017 (10)
    • ►  December (1)
    • ►  October (1)
    • ►  June (1)
    • ►  May (1)
    • ►  February (4)
    • ►  January (2)
  • ►  2016 (7)
    • ►  December (1)
    • ►  November (3)
    • ►  October (1)
    • ►  September (1)
    • ►  August (1)
  • ►  2015 (10)
    • ►  September (1)
    • ►  April (9)
  • ►  2014 (53)
    • ►  October (19)
    • ►  September (33)
    • ►  June (1)
  • ►  2013 (12)
    • ►  October (2)
    • ►  September (1)
    • ►  August (5)
    • ►  July (1)
    • ►  March (1)
    • ►  February (1)
    • ►  January (1)
  • ►  2012 (9)
    • ►  September (1)
    • ►  August (6)
    • ►  July (2)
Simple theme. Theme images by luoman. Powered by Blogger.