DSXchange

Is this problem only within this job, Are other jobs running?
If it is repeating thing in other jobs also then Ray's clue need to be taken care off.
What version of DS are you using?

Export Timing are kept under the Header of the dsx file. (Top of the exported file).

After Import not sure
In manager it shows Data/Time Modified against the job, but I guess that is specific to the job change only.

Do a Reset of the Job from the Director.
And see the log from previous run whether it gives any additional information of the failure.

Read the Sequential File with a sequential file stage with 5 columns specified in the metadata.

Drag it into the Transformer and Create three out links pointing to the three different tables.

In constraint of each link specify the condition of the rectype.
and you are done.

If the process is to be done for more than one file. Then include the activity of calling the routine and server job in between loop activity. But with that you would need to tweak the routine code a bit. Or you could read all the file names once and concate them with spaces and in server use them w...

Create a Routine which will read the parameter from the file.

Call this routine in a Sequence Job,
Call your Server Job from this Sequence job with a parameter having the value as the return value from the routine activity.

Use this parameter in the server job as the name of the sequential file.

Try clearing the Status File from the Director and see whether you are able to compile the job or not.

Try to see the locks held by the job if any through the DS.TOOLS. If there then try releasing them.

See if there are any uvsh.exe processes still there in the server through the task manager.

What do you mean by that?
You can execute this at the Administrator

When I try to bring records which have been either update or inserted in both those tables and then try to do a full outer join on those records some of the records might have empty values for the fields. -- Aditya. Can you share with us the structure of the Hashed File (especially the key structur...

Create two different server jobs one with the first ODBC link to the Hashed File stage with the appropriate transformations. And the other with the other two ODBC populating the Hashed file. Call these two jobs within a Seqnece Job using the job activity stages and put link between the job activity ...

Check whether the job being called is in the runnable state or not, if it is not then compile it and rerun the sequence job.

The descriptions are stored within the DS_JOBOBJECTS, not with the DS_JOBS, that's why you could not find it in DS_JOBS.

Try

DSGetLinkInfo("sample","link","Link",DSJ.LINKROWCOUNT)

Use it in after job subroutine, to make sure that whole job has run completed successfully.

Try

Meaning for every record you want to execute the script?

For that you can you can use DSExecute call (within the transformer).