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,062 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,721 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,448 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,190 reads

Blogs

Clustering SAP #ASCS and #ERS on #AWS using Windows Server Failover Clustering

By

When ensuring high availability for SAP ASCS and ERS running on WIndows Server, the...

Heading Font Weights and List View Toggles Arrive in Block Editor and WordPress 5.8

By

With the WordPress 5.8 release, we're starting to introduce features that overall improve your...

My Application is Getting SQL Timeout Errors, But What Query is the Problem?

By

This is something that comes up time and time again. A developer or member...

Read the latest Blogs

Forums

convert hours into decimal

By jeannier1975

i have a formula that calculates the difference between two dates and tells me...

Get charges percentage per entity\channel

By Bruin

I trying to figure out what percentage of the total charge for a ME...

How to find islands and get max and min range values

By itlk

I am trying to create groups for each Name and save the max and...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers