Failed Job Notification

This script notifies the DBA or Developers with the list of failed jobs. This script useful if you want to use either Mater-Target server option or even single server to monitor the Target servers jobs. You must have SQL MAIL configured on the SQL Server.

2006-02-20 (first published: )

2,059 reads

Delete Old backup Files

The following script deletes files in the specified folder, older than specified no of days and outputs the details to the specified file location. I use this VB script to delete some old backup files those can't be deleted with the regular maintenance plans. All you need to do is to supply the backup folder […]

5 (2)

2006-01-20 (first published: )

1,716 reads

Database File(s) Growth Notification

This stored proc notify the user(s) if the data/log file grew. When you execute it for the first time it will get the data/log files sizes and inserts in a table. Next time when you run the script if will compare the current size with the previous files size. This script must need sqlmail configured […]

2003-11-07

1,441 reads

Errorlog Notification

This script Notifies the user(s) whenever there is an Error logged in the Error message. It excludes the Error messages 15457 and 1073759806. These 2 Errors can be ignored. (I know we like to keep our Elogs clean but for some time you need to yield to them J ). You’ll see the first error […]

5 (1)

2003-10-30

1,185 reads

Blogs

Daily Coping 9 Apr 2020

By

I’ve started to add a daily coping tip to the SQLServerCentral newsletter, which is...

Webinar: How to unlock the value of frequent deployments

By

I’m doing a webinar next week, on Wednesday, April 15, 2020, that looks at...

SSMS 18.5 Fixes from Redgate

By

I wrote yesterday about the issues with SSMS 18.5 and some of the add-ins...

Read the latest Blogs

Forums

ALWAYS On Setup problem

By interest

While configuring N1 and N2  Nodes connected to DC  Domain Controller working fine. Establishing...

Do You Have a Mentor?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Do You Have a Mentor?

Counting Rows in DAX

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Counting Rows in DAX

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers