DSXchange

The option would work for sure but here the requirement is to send out only 1 email notification and that would have the failed job names. If I include the job status in email option that would contain too much information and the users are not really interested for it.

Thanks

Thanks Ray.

Activity variable would determine whether the job failed or not and need to have seperate failure links to send email but that would be for each job.

But, say out of my 10 jobs 3 failed, how do I send out only 1 email notification with these 3 job names that failed.

Thanks

Sorry, forgot to mention that I need to send out only 1 email notifcation with all the failed job names.

Thanks

Hi, I have a job sequence where there are 10 jobs running in parallel and all of them need to run even in case some of them fails. How do I send out email notification only for the jobs that failed during execution? Is there a way in Datastage I can acheive this? Appericiate your time and thanks in ...

Hi, Though I have seen similar issue posted but could not get any resolution for the issue. I have a sequence job which call couple of child sequences and other jobs, though it was executing fine till now, though not made any changes, started throwing ABORT status during the half way of execution an...

Oh okay, thanks for the clarification.

Thanks

Thanks Ray, made the change and it did work. Adding to this will it be possible to get the name of job which failed in the sub sequence and add to the notification in the main sequence.

Any suggestions please.

Thanks

Hi, In the main job sequence I have 5 parallel jobs and 1 job sequence being executed, in the job sequence I have 10 parallel jobs to be executed (in parallel). So have put in sequencer to notify the users if a particular job in this fails and other jobs would need to execute. For example, if 2 out ...

Yes, the syntax is as,

ISNULL ( check_expression , replacement_value )

Thanks.

To mention the error,

The error is "Undefine data type 0"

Thanks.

Hi, I am facing a strange issue with try to execute a "user defined sql" which has sum function on a case statement. sum(case when (rd.rollup_data_point_id = 3 and rd.entity_type_id = 1) then isnull(rd.data_point_float,0) else 0 end) as msref_ltv, Here the same query is working fine when e...

Hi, Facing an issue using the DRS Connector stage, the job design is straight forward. Sybase stage -> transformer -> DRS connector stage Basically I am using the ODBC to connecto the target database and during execution got the following error. DRS_Connector_167: Required property /Connection/VARIA...

Thanks Ray, since the columns are not business critical we are ignoring for now.

To achieve we moved on to DataStage 8.5 and now it is all set.

Thanks

Please excuse, I should have posted in the Enterprise edition.

Thanks.