Mail Archive Search: <+subject:/^(?:^\s*(re|sv|fwd|fw)[\[\]\d]*[:>-]+\s*)*SQL\s+Query\s+Challenge\s*$/>

Results:

References: [ +subject:/^(?:^\s*(re|sv|fwd|fw)[\[\]\d]*[:>-]+\s*)*SQL\s+Query\s+Challenge\s*$/: 6 ]

Total 6 documents matching your query.

1. SQL Query Challenge (score: 1): Author: "Coats, Jack" <Jack.Coats AT BANKSTERLING DOT COM>; Date: Thu, 18 Mar 2004 14:41:26 -0600; Ok, this is really something I don't quite know how to do. My boss wants a report daily that has the name of nodes that failed on their last backup attempt, and and the last time they has a successfu; /usr/local/webapp/mharc-adsm.org/html/ADSM-L/2004-03/msg00537.html (11,249 bytes)
2. Re: SQL Query Challenge (score: 1): Author: James Lepre <jlepre AT NECA DOT ORG>; Date: Thu, 18 Mar 2004 15:42:23 -0500; Jack, You can try this Last nights Backup select Entity,Successful,Bytes,Examined,Affected,Failed from summary where activity='BACKUP' and cast((current_timestamp-start_time)hours as decimal(8,0)) <; /usr/local/webapp/mharc-adsm.org/html/ADSM-L/2004-03/msg00538.html (10,872 bytes)
3. Re: SQL Query Challenge (score: 1): Author: David E Ehresman <deehre01 AT LOUISVILLE DOT EDU>; Date: Thu, 18 Mar 2004 15:47:37 -0500; Define "failed". 1) did not run 2) ran but did missed some files 3) ran but missed some filespaces 4) all of the above 5) some combination of the above Ok, this is really something I don't quite know; /usr/local/webapp/mharc-adsm.org/html/ADSM-L/2004-03/msg00540.html (11,466 bytes)
4. Re: SQL Query Challenge (score: 1): Author: "Coats, Jack" <Jack.Coats AT BANKSTERLING DOT COM>; Date: Thu, 18 Mar 2004 15:10:03 -0600; Sorry, I should have been more explicit. Currently I run a query that is: QUERY EVENT * * BEGINDATE=TODAY-1 BEGINTIME=08:00 ENDDATE=TODAY ENDTIME=NOW EXCEPTIONSONLY=YES FORMAT=STANDARD Todays report; /usr/local/webapp/mharc-adsm.org/html/ADSM-L/2004-03/msg00542.html (13,882 bytes)
5. Re: SQL Query Challenge (score: 1): Author: "Coats, Jack" <Jack.Coats AT BANKSTERLING DOT COM>; Date: Thu, 18 Mar 2004 15:25:35 -0600; That didn't come out right. ... Here is the report: Scheduled Start Actual Start Schedule Name Node Name Status -- -- -- -- -- 03/17/2004 20:00:00 03/18/2004 04:17:28 DAILY HOUCYPRSTA Failed 03/17/20; /usr/local/webapp/mharc-adsm.org/html/ADSM-L/2004-03/msg00543.html (11,706 bytes)
6. Re: SQL Query Challenge (score: 1): Author: David E Ehresman <deehre01 AT LOUISVILLE DOT EDU>; Date: Fri, 19 Mar 2004 08:21:09 -0500; Just realize that "Success" in that context only means the backup session ended "normally", not that all the files were successfully backed up. David Sorry, I should have been more explicit. Currentl; /usr/local/webapp/mharc-adsm.org/html/ADSM-L/2004-03/msg00557.html (14,159 bytes)

Current List: 1 - 6
Page: [1]