Assuming we have the following table (that stores hierarchical data) :CREATE TABLE [staff] ( [employee] [int] NOT NULL , [employee_name] [varchar] (10) NULL , [supervisor] [int] NULL , PRIMARY KEY CLUSTERED ( [employee] ) ON [PRIMARY] , FOREIGN KEY ( [supervisor] ) REFERENCES [staff] ( [employee] ))I ‘ll built a […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

2002-08-23

825 reads

Discuss

First N longest running jobs per day

by damcalcan

SQLServerCentral

Maintenance and Management

Query that displays first N longest running jobs per day

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

1 (1)

2002-06-06

473 reads

Discuss

Alert When Not Enough Free Disk Space

by damcalcan

SQLServerCentral

Miscellaneous

--Implement an Alert Which Trigger when Specified Disks--free space exceeds a specified alert level--Steps to implement:--1) Define a Custom Error Message with messsage text (The ---drive free space is bellow alert level. Details: %s)--2) Define an Alert linked to CEM defined at step 1--3) Implement a Job which execute the following step in a recurring […]