tag:blogger.com,1999:blog-86137490548638920082012-02-16T18:33:17.947-08:00IBM Websphere Datastage 8.0 Server Edition TricksAnton Kudinovhttp://www.blogger.com/profile/15117529608543989199noreply@blogger.comBlogger21100tag:blogger.com,1999:blog-8613749054863892008.post-86754842220204370412009-06-16T23:35:00.000-07:002009-06-17T06:50:13.796-07:00Some time I have a problem with scheduled jobs - if server was restarted while job running - job status after this become aborted and schedule don't work. For solve this problem I write a routine to reset job if it's status is aborted. I schedule it for 5 minutes before start of main job.<br /><br />Parameter: jobname - name of reseting job<br /><br /><span style="font-style: italic;"></span><blockquote><span style="font-style: italic;">$INCLUDE DSINCLUDE DSJ_XFUNCS.H</span><br /><span style="font-style: italic;">$INCLUDE DSINCLUDE JOBCONTROL.H</span><br /><br /><span style="font-style: italic;">JobHandle = DSAttachJob(jobname, DSJ.ERRNONE)</span><br /><br /><span style="font-style: italic;">if JobHandle = 0 Then</span><br /><span style="font-style: italic;"> Call DSLogFatal('Job ' : jobname :' is not found', 'jobReset')</span><br /><span style="font-style: italic;"> Ans = 1</span><br /><span style="font-style: italic;">End Else</span><br /><span style="font-style: italic;"> jobstatus = DSGetJobInfo(JobHandle, 1)</span><br /><span style="font-style: italic;"> if jobstatus <> DSJS.RUNNING Then</span><br /><span style="font-style: italic;"> Call DSLogInfo('Job ' : jobname :' is not running', 'jobReset')</span><br /><span style="font-style: italic;"> if jobstatus = DSJS.RUNFAILED Then</span><br /><span style="font-style: italic;"> Call DSLogInfo('Job ' : jobname :' is aborted. Try to reset it', 'jobReset')</span><br /><span style="font-style: italic;"> RunErr = DSRunJob(JobHandle, DSJ.RUNRESET)</span><br /><span style="font-style: italic;"> if RunErr = 0 Then</span><br /><span style="font-style: italic;"> Call DSLogInfo('Job ' : jobname :' is reset', 'jobReset')</span><br /><span style="font-style: italic;"> End</span><br /><span style="font-style: italic;"> End</span><br /><span style="font-style: italic;"> End</span><br /><span style="font-style: italic;"> Ans = 0</span><br /><span style="font-style: italic;">End</span><br /></blockquote><div class="blogger-post-footer"><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/8613749054863892008-8675484222020437041?l=mydatastage.blogspot.com' alt='' /></div>Anton Kudinovhttp://www.blogger.com/profile/15117529608543989199noreply@blogger.com4tag:blogger.com,1999:blog-8613749054863892008.post-90786403906628606752009-06-16T23:24:00.000-07:002009-06-16T23:26:40.489-07:00I'm working with IBM Websphere Datastage 8.0 Server Edition.<br /><div id="result_box" dir="ltr">In this blog, I posted the interesting thoughts and findings obtained during the work with Datastage.</div><div class="blogger-post-footer"><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/8613749054863892008-9078640390662860675?l=mydatastage.blogspot.com' alt='' /></div>Anton Kudinovhttp://www.blogger.com/profile/15117529608543989199noreply@blogger.com0