Script to check status of database and mail to dba

Question

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

ramses2nd Hall of Fame Points: 3720 More actions · Answer 1

One way I have done this is to check the status of the server by issueing a command like:

xp_cmdshell 'sc \\yourservername query mssqlserver'

You could then input the results into a table and absed on the result issue a xp_sendmail command.

vaddi SSC Veteran Points: 223 More actions · Answer 2

Thanks for the command.

Can you let me know , how to write the command for xp_sendmail.

Thanks

ramses2nd Hall of Fame Points: 3720 More actions · Answer 3

Here is an example:

IF EXISTS (

SELECT * FROM some_table WHERE value LIKE value &nbsp

BEGIN

EXEC master..xp_sendmail @recipients = 'email_address',

@message = 'email message',

@copy_recipients = 'other_email',

@subject = 'Subject Title'

END

GO

barsuk SSChampion Points: 12280 More actions · Answer 4

If checking for DB status, you may want to go that way:

SELECT DATABASEPROPERTYEX ('YourDB','STATUS')