This script will drop a mail for sql drives if space on drives is below set threshold value. Log drives with 15 and data files drives with value of 10% as threshold value of free space.
2015-11-19 (first published: 2015-10-27)
1,982 reads
2015-10-19 (first published: 2013-08-30)
4,332 reads
This script validates the sufficient disk space per drive.
When you'll reach a minimum on a diskdrive, the script will mail all recipients.
2011-12-07 (first published: 2011-10-28)
3,858 reads
This is an effort to program the "Estimating the Table size" section given in BOL.
2009-07-06 (first published: 2009-06-19)
1,725 reads
2009-03-04 (first published: 2009-02-16)
1,241 reads
Comments posted to this topic are about the Question of the Day for 11 Oct 2004 posted at http://qa.sqlservercentral.com/testcenter/qod.asp?QuestionID=354.
2004-08-23
1 reads
Try taking advantage of SQL jobs.We did the same you are trying to do like this.Set up a Job with say 2 steps.Step 1 searches for that file, if it is found goto step 2, otherwise try again in 5 minutes.Step 2 Do what ever you need to with the file. There are some more advanced […]
2004-02-23
My task is to output the text from "MissingSales_Tble" which changes every 15 minutes based on how many stores didn't transfer in their sales file.There are 3 possibilities in MissingSales_Tble: 1 or 2 areas has missing salesAreaMessageStore_NumCNMissing Sales as of 2/10/2004 11:05:00 ABK00522WINo Missing Stores CSNo Missing Stores all areas have missing salesAreaMessageStore_NumCNMissing Sales as of […]
2004-02-10
Allen- Thanks for your response. I tried this already. It did not change anything. I am running Windows 2003 and SQL Ent edition. SQL patched to 3a.
2003-12-16
1 reads
Oops. Was that QOD 26/11 was it? And there's already a thread discussing it? And it's already been adequately explained? I'll just crawl back under my rock and hope the site administrators will delete this totally useless thread. Cheers, - Mark
2003-11-26
1 reads
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers