开发者

Identification of Datastage latest modified jobs

How to identify the jobs which are modified today in datastage 8.1. T开发者_C百科hanks Raghu


Programmatically or by hand?

As of 8.x at least there is a Tools->Advanced find that lets you search by modification date including "Today".


my environment: rhel4 ds8.1 reposity metadata:db2

the below code is usually used:

 - select
   (timestamp('01/01/1970','00:00:00')+(xmeta_creation_timestamp_xmeta/1000)
   seconds) as
   creation_time,(timestamp('01/01/1970','00:00:00')+(xmetamodificationtimestampxmet/1000)
   seconds) as modified_time,a.*
       from 
       xmeta.datastagex_xmetagen_dsjobdefc2e76d84 as a
       where name_xmeta=dsjob_name

you can change the where condition to obtain the modified today job infomation.

 - where
   to_char((timestamp('01/01/1970','00:00:00')+(xmetamodificationtimestampxmet/1000)
   seconds),'YYYYMMDD') = to_char(current timestamp,'YYYYMMDD');


Infosphere Information Server Manager will give you a nice GUI interface where you can go to the code in question ; it will tell you the the create date , the last modifying date and the create user and last modifying user.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜