一、JOB的分类与作用(?)
1、Server JOB:
最为常用的Job类型,Job可以组合使用,Server Job是Job的最小单位。
原文档:If you have the Web Services pack installed an additional check box, Web Service Enabled, appears. Select it to indicate the job can be made available as a web service.
2、Parallel JOB:
3、Mainframe JOB:运行于大型机的JOB。
4、JOB Sequences:Job Sequence主要用于Job间的协作工作控制,如各Job的实行流程,出错处理,文件监控等。
二、jobstatus的用法
jobstatus
–jobstatus waits for the job to complete, then returns an exit code derived
from the job status.
命令格式为:
dsjob –run
[ –mode [ NORMAL | RESET | VALIDATE ] ]
[ –param name=value ]
[ –warn n ]
[ –rows n ]
[ –wait ]
[ –stop ]
[ –jobstatus]
[–userstatus]
[-local]
project job
三、判断NULL值
实例
STAGE :JOIN STAGE
设置:
LEFT JOIN
左输入语句:SELECT * FROM PMP_Insured_Amount
右输入语句:SELECT COL_ID
,TAB_NAME
,WORK_DATE
,REF_COLUMN1 AS UNIQUE_ID_IN_SRC_SYS