DSXchange

select EVAL DS_JOBOBJECTS."@RECORD<6>" AS FILE_NAME FMT '45L', DS_JOBS.NAME AS JOB_NAME FMT '35L', DS_JOBOBJECTS.NAME AS LINK_NAME FMT '35L' from DS_JOBOBJECTS, DS_JOBS where DS_JOBOBJECTS.OLETYPE in ('CSeqOutput','CSeqInput') and DS_JOBOBJECTS.OBJIDNO = DS_JOBS.JOBNO group by FILE_NAME, ...

reddy wrote:Hi,

Thanks for reply.

But i am not using a Sequence this is only a single job,How can i run a job with Reset if Required and then Run option like in Job Sequence.

Thanks
Reddy

How r u running your job?

Is it manually/ through Jobcontrol/ ?

Can I ask whether you connect with the Omit box checked, or supply a user id and password? If you do use Omit, try providing an explicit password. In many ways connection via LAN Manager rather than TCP/IP (which is what Omit does) is flaky. Hi Ray, We never connected by checking Omit box. We alway...

roy wrote:Hi,
Check the box for adding check-points in the properties of the sequence job.
p.s.
sequencer is the name of a stage in a sequence job
IHTH,

Hi Roy,

I did add check-points int the properties of the Sequence job.
But that didn't help.


Thanks

I have a Sequencer which runs 5 jobs. A -->B--->C1--->D A -->B--->C2--->D Job A, Job B runs one after the other . Job C1 ,Job C2 run in parallel after completion of Job B. Job D runs after successful completion of C1 & C2 . ********************Scenario*************************** Jobs A & B a...

There is a patch for this from IBM. Hi Duke, Can you please clarify me which patch it is exactly. I don't see such patch on IBM website. Only patch i see related to this is " dsclient_xpsp2 "(atl.dll,DataStageSwitcher.dll,DSDesign.exe.local,setup,log,ecase60128-readme) , which we already ...

ray.wurlod wrote:When you uninstalled the clients, did you check that it had been removed from the Registry?

No we didn't do that , Ray.
Should we be doing that every time we uninstall DataStage on any machine?


Thanks in Advance.

We are facing Designer crashes , lot of times, when working with Sequencers in 7.5.1A . Has anyone facing this kind of issue? We opened case with IBM and response was: "there must be some kind of conflict with or perhaps something happened to your client. Have you tried uninstalling/installing ...

Logic, There is no exception handling or email notification in the sequence. Its a simple single line of job flow with only four job activities. Each job activity triggers the next if it 'Executed OK'. Thanks. Did you check these options in JobProperties: "Add checkpoints so sequence is restar...

We had Rebuilt the Server and reinstalled the DataStage & VersionControl software. Reimported the jobs into DataStage projects and also for the VERSION project. We were able to see all the jobs in DataStage projects, without any issue. But we could not able to see any default settings/jobs in th...

Hi, I am trying to make my job sequences restartable when one of the jobs has aborted. The add checkpoints property is turned on for the job sequence. The property is turned on in the administrator too. When a job in the sequence has aborted the the logs in the sequence says the job status aborted ...

User B(I) logged on to my work computer through VPN and browsed job logs for couple of minutes and then did some queries in SQL Server Query Analyzer. After around 10 minutes job failed with warnings.
There are no parameters used in our shop which are same as my NT id.

Thanks
Sathish

We are running some jobs in Production. These jobs are submitted by some User A ,through VPN . User A submitted a Sequencer,which inturn started a JobControl and within it which runs a job. User B tried to view the log for that job through VPN from home. All the jobs logged a warning in Sequencer,Jo...

This is a SQL Server process. You have to fix the problem in SQL Server. DataStage is simply informing you that the problem exists, and is preventing DataStage from doing its task. Hi Ray, Thanks for your Reponse. But why does that DataStage job gave warning about SQL Server , when that job is not ...

We ran a job on 09/27/2005 8:39:45 AM in Production. The job aborted at 09/27/2005 8:40:06 AM with PrimaryKey Violation Error. After deleting the data from a particular table , the job was Reset at 09/27/2005 8:46:19 AM and we Ran the job again. The job finished at 09/27/2005 8:46:59 AM successfully...