客户有一个需要,想要知道后台在运行的报表,
所以做了个简单的查询:
SELECT REPORTJOB.APPNAME ,
REPORTJOB.REPORTNAME,
REPORT.DESCRIPTION ,
REPORTJOB.USERID,
REPORTJOB.HOSTNAME,
REPORTJOB.SERVERNAME,
REPORTJOB.ISIMMEDIATE,
REPORTJOB.STARTTIME,
REPORTJOB.STATUS ,
REPORT.PRIORITY,
REPORTJOB.REPORTJOBID
FROM REPORTJOB ,REPORT
WHERE REPORTJOB.APPNAME=REPORT.APPNAME
AND REPORTJOB.REPORTNAME=REPORT.REPORTNAME