html判断是否大于0,html格式邮件监控failures大于0的job

create or replace procedure sp_job_check as

v_counter number;

v_html varchar2(30000);

begin

select max(failures) into v_counter from dba_jobs;

if v_counter>0 then

v_html:='xmlns="">';

v_html:=v_html||'

';

v_html:=v_html||'

';

v_html:=v_html||'

v_html:=v_html||'

';

v_html:=v_html||'

jobSCHEMA_USERLAST_DATEFAILURESBROKENINTERVALWHAT';

v_html:=v_html||'

';

for mm in ( select job,SCHEMA_USER,to_char(LAST_DATE,'yyyy-mm-dd hh24:mi:ss') last_time,WHAT,INTERVAL,FAILURES,BROKEN from dba_jobs where failures>0)  loop

v_html:=v_html||'

';

v_html:=v_html||'

'||mm.job||''||mm.SCHEMA_USER||''||mm.last_time||''||mm.FAILURES||''||mm.BROKEN||''||mm.INTERVAL||''||mm.WHAT||'';

v_html:=v_html||'

';

end loop;

v_html:=v_html||'

';

v_html:=v_html||'';

v_html:=v_html||'