DSXchange

Our requirement is to run the jobs in particular category and if any job is failed or finished with warning then send an email for that particular job name. I'm using the below code to check the status of all jobs in a category and even able to send an email but somehow the subject of email is not d...

Hi Gurus, I've created a batch job which run all the jobs in parallel from a category. I want to send an email if the job is finished with warnings with subject as job name or message as job name. I'm able to send email for any jobs abort or finished with warnings but the subject is not dynamic i.e....

Tried everything but its same. Can we delete categories from command line.

Thanks,


[quote="ray.wurlod"]It's probably not the files but the indexing.
Get exclusive access to the project and execute [b]DS.REINDEX ALL[/b][/quote]

Hi, They are empty directories and gives message "Record Category_Name in the file DS_JOBS does not exist" even when we open up designer window pops up for each such directories and we have to click several times before opening up the job in other category. Is there a way to clean up DS_JO...

Hi ray,

I tried it deleting, refreshing, even logging it again ...doing it from different m/c but its same.

Thanks,

Hi,

We are not able to delete few empty Categories, tried it from manager, designer but it gives the message "Record Category_Name in the file DS_JOBS does not exist.

Thanks,

Its defined in oracle as integer so shall we define it as Int 10 in coloumn defination DS job irrespective of fact that metadata import defination bring it as Decimal 38. Thanks, Welcome to the wunnerful world of Oracle bin Larry! Oracle has only NUMBER for numeric data types. Therefore, when one in...

Hi, we are developing a job which will load to a Oracle table with column type integer. When I import the table defibnation thru' Ora plug-in its defination is Decimal 38 Display 40. Further going we will be having 100's of etl's which will be using same metadata type as Integer wanted to know do we...

One of the method Step 1--Job1 - Extract the values from source B in hash file (will remove the duplicate values) Step 2 - Routine -- To read the hash file and return the value in ('value1','value2',.....) format Step 3- Job 2 -- To extract the data from system A and use the return value of routine ...

In sql before tab use the Truncate statement or crate the sp and call it in sql before tab.


Clear and insert option will take al ot of time i.e. 17m rows.

Thanks

That what I was trying to do nut not succesful as how can you tell Iconv function that its particular format if not then go to next condition. It might be simple but not clicking to me :-( Thanks I think if you know the number of distinct format then using iconv and if condition change the target fo...

YYYY-MM-DD MM-DD-YYYY DD-MM-YYYY MM/DD/YYYY DD/MM/YYYY I need to check if its YYYY-MM-DD then ok otherwise conver it to YYYY-MM-DD Regards What are all the possible formats? Can you provide a list. ICONV with Date option should work for most of them. Thats why I requested for a list of all formats s...

Hi Gurus,

I've input date coming in all the different format , our requirement is to convert the date in YYYY-MM-DD format.

I tried using Iconv, Oconv combination but it fails at some point.
Wondering if there is any code available or I've tocreate a routine with case statement.

Thanks

If you check the box (after succesful completition of job run the after job subroutine).....and if your job finishes with warnings it executes the command for after job subroutine. Lil confusing as I thought succesful completition means clean run....but works for me :-) Thanks.... :idea: Why dont yo...

Hi,

I checked the checkbox only run after job subroutine after successful completition of Job. If the job finished with warning then will my After job subroutine will execute.

We need to execute the after job subroutine even if the job finished with warning but not if job aborts.

Thanks