Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Help in writing a query Expand / Collapse
Author
Message
Posted Tuesday, November 19, 2013 10:41 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, April 01, 2014 3:44 PM
Points: 1,266, Visits: 2,912

Attached is sample data in excel sheet. Basically i am trying to find out the keeps and drops for sql jobs.I couldn't come up with the write query. Sample data has only two servers, but there are more than 50 servers in actual data. I would like to do two things:

i) Identify jobs which can be dropped, if either one of the two below criteria satisfies then it is drop candidate
a) Same job should be disabled on all the servers (OR)

b) If it is enabled on any one of the server, then check if the last run > 6 months.


ii) Find list of jobs which cannot be dropped at all.

Thanks


  Post Attachments 
TempJob_New.xlsx (4 views, 24.52 KB)
Post #1515679
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse