Results 1 to 3 of 3
  1. #1
    Join Date
    May 2003
    Location
    California Coast
    Posts
    72

    Unanswered: need script to monitor os free space & errors

    I am looking for a script to check the os free space and email if getting below a threshold.

    Additionally, I am looking for another script to read the sql server log for errors and to email if error (or a string) is found.

    Mike

  2. #2
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    You can take help of ALERTS in SQL server for free space threshold, refer to books online for more information.

    Also can take help of Notification services or third party tools like BMC Patrol to alert if any error occurs in SQL error log/
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  3. #3
    Join Date
    Jun 2003
    Posts
    31
    Procedure for extracting error from Errorlog and send email:

    1) Open a notepad, cut and paste the following sample of errors
    that you would like to find:

    Error: 3414
    Error: 3437
    Error: 3619
    Error: 8651
    Error: 9002
    BACKUP failed to complete
    consistency errors
    Exception Access Violation
    .
    .
    .

    and save it as "search_list.txt"

    2) Open another notepad, cut & paste the below sample to
    extract the error and output to a file (C:\List_error.txt) if
    any error in the Errorlog is matched with the "Search_list.txt"
    provided above:

    IF EXIST DEL C:\List_errorlog.txt
    Findstr /i /g:C:\Search_List.txt D\MSSQL\LOG\errorlog >
    C:\List_errorlog.txt

    osql -Sservername -E -Q"xp_sendmail @recipients = 'DBA_on_call@yahoo.com', @message = 'See attached file for error',@attachments = 'H:\MSSQL\LOG\List_errorlog.txt', @subject = 'SQL Server Errorlog'"


    save it as a command file like "Search_error.cmd"

    3) start the Enterprise Manager and schedule a job that run the
    "Search_error.cmd" for every 10 min or whenever...

    Goodluck

    SVT

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •