08:21:46  Program Started at : 18/7/2017 8:21:46 Logged in by:SEC
08:23:41 SELECT tbPagingGroup.sPagerNo, tbPagingGroup.sCallingNo, tbPagingGroup.sPagingName FROM (tbJobExpireLocationByRoom LEFT Outer JOIN tbCallPath ON tbJobExpireLocationByRoom.sPath=tbCallPath.sPath) INNER JOIN tbPagingGroup ON tbCallPath.sPagerNo=tbPagingGroup.sPagerNo where tbCallPath.nLevel = 0 AND tbJobExpireLocationByRoom.sJobCode = '4071' AND tbJobExpireLocationByRoom.sFloor = '' AND ('082341' BETWEEN tbCallPath.dtStartTime AND tbCallPath.dtEndTime) order by tbCallPath.dtStartTime
08:23:42 SELECT tbPagingGroup.sPagerNo, tbPagingGroup.sCallingNo, tbPagingGroup.sPagingName FROM (tbJobExpireLocationByRoom LEFT Outer JOIN tbCallPath ON tbJobExpireLocationByRoom.sPath=tbCallPath.sPath) INNER JOIN tbPagingGroup ON tbCallPath.sPagerNo=tbPagingGroup.sPagerNo where tbCallPath.nLevel = 0 AND tbJobExpireLocationByRoom.sJobCode = '4071' AND tbJobExpireLocationByRoom.sFloor = '' AND ('082342' BETWEEN tbCallPath.dtStartTime AND tbCallPath.dtEndTime) order by tbCallPath.dtStartTime
08:24:54 Save Job:insert into tbJobMaster (nJobID, dtAddedDate, sAddedBy, nStatus, sRoomNo, sExtNo, sGuestCode, sJobType, sGuestName,  nAssignType, sAssignToDept, sAssignToUser, sRemarks, nIsNew, sNotifyUsers, sAddedUserDept,sJobCode,sCourtesy,Duration,dtNextExpire,sMobileNo,sOther,sQty,nPicture) values ( 7275,'2017-07-18 08:24:54.000','SEC', 1,'PA380','PA380','CommonArea','004',N'',1,'-','-',N'B1 #3 Staircase B1樓3號後樓梯-1xFluorescent tube fused 光管燒 係B1/F #9 梯換短光管 謝謝 ',1,'','Security','4071',0,30,'2017-07-18 08:54:54.000','-','係B1/F #9 梯換短光管 謝謝','1',0)
08:25:04  Program Exit at : 18/7/2017 8:25:04
09:20:04  Program Started at : 18/7/2017 9:20:04 Logged in by:SEC