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