Audit routines

shahidbakshi · Post by **shahidbakshi** » Tue Jan 13, 2009 5:36 am

Hi All,
Can anybody suggest me how to fetch stage names and link names which are named like source and target in job designs. Actually writing a routine to extract job information(job audit ) which dynamically searches for the source and target stages and get's the link row count pertaining to the stage.

Ex :
Sources Stages : abc_src, bb_src------------2 source stages
Source links: abc_srclink ,bb_src_lnk --------2 links (need to get rowcounts for these links only)

SImilarly for Target stages and links and get the record counts.

I am using DSGetLinkInfo function . For this i need to hardcode stages and links for which we need to modify each and every job.

src_cnt = DSGetLinkInfo(JobHandle, srcstg,srclnk , DSJ.LINKROWCOUNT)
tgt1_cnt = DSGetLinkInfo(JobHandle, tgtstg1,tgtlnk1 , DSJ.LINKROWCOUNT)

Any suggestions or ideas would be of great help to me . Thanks in advance.

Best regards
Shahid

ray.wurlod · Post by **ray.wurlod** » Tue Jan 13, 2009 2:48 pm

A source link will be an output link, and therefore have "Out" as part of its OLETYPE in its record in the DS_JOBOBJECTS table.

Once you have the record for the link, the key to the corresponding stage can be obtained by removing the Pnn part of the key to the link record. For example if the key to the link record is J\412\V0S2P2 then the key to the corresponding stage is J\412\V0S2.

LenGreenwood · Post by **LenGreenwood** » Wed Jan 14, 2009 6:03 am

Assuming what you want to do is find the names of all links of all stages in a job, and can then use pattern-matching on the link names to decide which ones to call via DSGetLinkInfo - e.g. ending in "_src" or "_tgt" or somthing like that:-

DSGetJobInfo(JobHandle,DSJ.FULLSTAGELIST ) returns a comma-separated list of stage names for the job you have attached to.

Then DSGetStageInfo(JobHandle, StageName, DSJ.LINKLIST) returns a comma-separated list of link names for a given stage name extracted from the stage list - e,g, via the Field() function.

shahidbakshi · Post by **shahidbakshi** » Thu Jan 15, 2009 10:22 pm

"can then use pattern-matching on the link names to decide which ones to call via DSGetLinkInfo - e.g. ending in "_src" or "_tgt" or somthing like that:-"

Please could you suggest how to perform pattern matching on the links.

.

Thanks in advance

LenGreenwood · Post by **LenGreenwood** » Fri Jan 16, 2009 2:38 am

Have a look at the MatchField() function or the Matches operator in the BASIC Reference Guide.

Note that this uses different pattern syntax from what you may be used to - it is not the same as "regular expressions" you find in C etc.

Something like

Code: Select all

If string Matches "0X'src'" Then 
....

will return true if the string ends with the letters 'src'.

shahidbakshi · Post by **shahidbakshi** » Fri Jan 16, 2009 5:30 am

Thanks a lot for the kind information.

Regards
Shahid