MSCITS Job Status

JobNumber	JobStatus	JobType	RequestDate	Results
5317	Closed	BLANK	9/20/2000
5399	Cancelled	Activate	10/12/2000
5400	Cancelled	BLANK	10/12/2000
5401	Cancelled	Activate	10/12/2000
5402	Cancelled	Activate	10/12/2000
5471	Closed	BLANK	11/4/2000	logged by sed.
5994	Closed	BLANK	4/17/2001	logged by sed.
8537	Closed	BLANK	2/14/2003	logged by sed
9081	Cancelled	Activate	7/18/2003
9871	Cancelled	Miscellaneous	1/27/2004	logged by sed. See job 9864
10537	Cancelled	Document	6/18/2004	logged by sed. What line id?
10890	Closed	Document	8/31/2004	wcfb-4a-4001 - larry called 9/30 - should be billed to Peds
12236	Closed	Document	7/1/2005	logged by sed.
13138	Closed	Document	7/21/2005
14093	Cancelled	Document	8/2/2006
14149	Closed	Document	8/14/2006
14251	Cancelled	Line Move	9/6/2006	buzz checked out. Just needed patch cable.
15624	Cancelled	BLANK	6/12/2007
15824	Scheduled	Document	7/30/2007
17337	Scheduled	Miscellaneous	7/22/2008
17933	Closed	Document	12/11/2008
18120	Closed	Install/Activate	1/15/2009	see 17725 AND 18146
18294	Scheduled	Document	2/24/2009
18358	Cancelled	Miscellaneous	3/13/2009	see job 18362
19397	Closed	Miscellaneous	11/11/2009

Sort By: [Job.Description] [1 - 25 : 18041]
The following data is the associated Line number(s) and IP addresse(s) for the displayed job.There may not be any records associated with the job.

Error: No record found
SELECT COUNT(1) FROM Unumber,ActivityType A,ConnectionType C WHERE A.activitytypecode = Unumber.activitytypecode and C.connectiontypecode = Unumber.connectiontypecode and Unumber.Jobnumber ='5317'