This script will create a procedure to list all databases on the server (except tempdb), the last time the database was backed up (database backup, not log backups), and a comment which could be customized. For my purposes, I flag any database which hasn't been backed up in the last week. This provides a quick […]
2002-06-14
3,102 reads
For jobs that run periodically and should take only a short time to run, a DBA may want to know when the job has been running for an excessive time. In this case, just checking to see IF the job is running won't do; the ability to make sure that it hasn't been running for […]
2002-01-15
3,787 reads
This script will allow you to create a stored procedure that will check a server for any jobs that have failed in a specified number of days. It has proven valuable to me, since I have servers with lots of jobs that run frequently; I got tired of checking the history of each job to […]
2002-01-01
3,943 reads
By Angela-Henry
I am very excited to announce that I will be speaking for Data Saturday...
By Angela-Henry
I am super excited about this new version of Data Weekender, coming up on...
By Steve Jones
I have to thank Kathi and Mala for putting on the WIT Mental Health...
Comments posted to this topic are about the item Checking Up on Vendors, which...
Hi Forum, I want to search a Database for a String value and I...
Hello Friends, Posting this for help as the client made more requirement changes. I...
Ask SSC