DSXchange

I just wanted to know that is there a way to find out all the jobs which use a Particular Environment Variable??
For EG. If I have 50 Jobs and 25 of them use Environment variable DATABASE_TYPE then is there way to get list of all those tables??

Oops..sorry guys.... I am still wondering wht will happen in this case in Windows....

All , Just wanted to know tht what will get stored in DS_AUDIT if we create a job after logging in by Omitting the Password ??

May be that what he means that he is not getting correct info.

One reason of this error popping up is because the routine was moved to a different place. Also please note that the GetNextBatchNumber routine is a delivered routine with EPM and it utilises a Hashed file to generate Batch Numbers. Please look in to the Hashed Files (access available , is present e...

The job may have stopped but the job will keep on showing the warnings til the end (last warning).

If you do not want to continue then you will have to rename the job so that the PID changes. But I think the log will remain the DS folder as it may not delete it as it is still writing.

Well there is one complex way that it can be done if you really want to do it -- 1. Write a routine which will find out the last day of the friday. (Find out what is the last day and date in the month and subtract a number from it to reach the last friday). 2. Design a job and call this routine in i...

Usually occurs when the CSV files have extra spaces in between the names or after or before the name. Trim may remove the issue but u will have to put trim in both the stages , lookup ad well the source or the names which have spaces in the DB will get rejected. Testing - You can change the query by...

Yes it did. Thanks.

What happens when you use a Execute Command Stage and call this Bat file there?

Are u saying this Bat file itself is not working??

Search for RT_LOGnnn and you will get many posts regarding this. THe simplest way to do this will be to delete the job and then reimport it ...

Thank you..Can be the reason as the Job log is huge. Will Auto purge the log for the particular Job and check out if it works..

When you say delete files related to the job do you mean the output files generated by the job or the internal ones.

You can call a BAT file by a Comman Stage.

Yes , No req of a Database to install DS server.

Well , yes I will for sure. But not sure how to find that out. No one is running anything at that time on the server as well. Grrrrr.... ..

I did this last week. Deleted the Job and Reimported it in the project , but this error came up again this week. DO I have to do it again??