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

AWS RDS SQL Server Announcements - 2019

By

1.    Amazon RDS SQL Server Supports differential and log and restores: https://aws.amazon.com/about-aws/whats-new/2019/11/amazon-rds-for-sql-server-now-supports-differential-restores-and-log-restores/  2.    Amazon RDS SQL...

AWS RDS SQL Server Version List

By

AWS RDS SQL Server 2017 Builds RDS...

What is a strong password anyway?

By

Background Fellow Microsoft MVP Troy Hunt (blog | Twitter) has been operating the website Have...

Read the latest Blogs

Forums

Looking for SQL Code

By patla4u

Hi I am having situation where I would like to update the existing data...

Looking for SQL Code

By patla4u

Hi I am having situation where I would like to update the existing data...

SQL Server new Linked Server

By Bristool123

hello my friends. I have a suuuuuper weird question about sql server, at my...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers