Windchill SQL篇之 列队相关sql

/*  工作安排  任务状态分组统计*/
select b.name,
       a.codec5,
       count(*)
  from windadmin.schedulequeueentry a, windadmin.schedulequeue b
 where a.ida3a5 = b.ida2a2     
   group by b.name,a.codec5; 
   
/* 在运行的进程 */ 
select b.name,a.startexec,a.startexec + 1 / 3, round(（sysdate - (a.startexec + 1 / 3)）* 24 * 60,2) || ' min ' as 持续时间, a.entrynumber,a.*
  from windadmin.queueentry a, windadmin.processingqueue b
 where a.ida3a5 = b.ida2a2
   and a.codec5 in ('EXECUTING');
   
/* 在运行的工作安排 */ 
select b.name,a.startexec,a.startexec + 1 / 3, round(（sysdate - (a.startexec + 1 / 3)）* 24 * 60,2) || ' min ' as 持续时间, a.entrynumber,a.*
  from windadmin.schedulequeueentry a, windadmin.schedulequeue b
 where a.ida3a5 = b.ida2a2
   and a.codec5 in ('EXECUTING');

/* 失败的队列 */
select b.name,
       a.codec5,
       a.createstampa2,
       a.messagec5,
       a.targetclass,
       a.targetmethod
  from windadmin.queueentry a, windadmin.processingqueue b
 where a.ida3a5 = b.ida2a2
   and b.name = ''; --队列名称