IBM Infosphere Datastage - Working with Job Status and User Status

 

In Datastage, every job can have Job Status and User Status.  We can query Job Status but user can not set the job status to custom string. The user status in other hand, user have to set and then can be queried in the sequence jobs. 

In the following link, Timm Ruger provided very good information about both UserStatus and JobStatus

http://www.tr-itconsulting.com/blog/userstatus

The user status can be set using two ways

1. Using the BASIC transformer

2. Writing BASIC functions in the Job Control

Call DSSetUserStatus("sales job done")
Call DSLogInfo("JobControl Executed","JobControl")

As you can see in the about screen shot, I have also added a info message to log in order to test when do this Job Control get executed (Before the job itself or after). as a result I found that the Job Control is executed before the job itself

Once the UserStatus is set it can be retrieve from the Sequence jobs. We can control the branching using this userstatus in the triggers tab for job activity only.  or can retrieve this user status from the next activities (this is one of the activity parameter , the other two are $JobStatus and $JobName)