Sending an E-mail if wrong data is coming in
Posted: Wed Jul 27, 2005 10:58 am
Hi All,
I need to do this. I have seven jobs. These seven jobs are sequenced in a master sequence. The jobs do the follwing:
1. Job1 --- pulls data from an ODBC connection, parses it and loads it into a flat-file.
2. Job2 ---pulls data from a ODBC connection and loads it into a hash file.
3. Job3 ---pulls data from a ODBC connection and loads it into a hash file.
4. Job4 ---pulls data from a ODBC connection and loads it into a hash file.
5. Job5 ---pulls data from a ODBC connection and loads it into a hash file.
6. Job6 ---performs look-ups on all the above hash files using the flat-file (in job1) as the source file.
7. Job7 ---Master sequence which sequencesthe job as below:
Job1-->job2-->Job3-->Job4-->Job5-->Job6
Questions:
1. Will the jobs abort if the source ODBC is down and datastage is not able to access the data files?
2. If the value i'm looking up is not found in the hash file, How can I send this source record to a reject file and simultaneously notify by e-mail?
3. If suppose, the source data has character coming in instead of a numeric, how can I send this to a reject file and again notify by e-mail that these records were rejected?
Please note that it is a windows environment, not UNIX.
Please help me out!
Thanks much,
Naveen.
I need to do this. I have seven jobs. These seven jobs are sequenced in a master sequence. The jobs do the follwing:
1. Job1 --- pulls data from an ODBC connection, parses it and loads it into a flat-file.
2. Job2 ---pulls data from a ODBC connection and loads it into a hash file.
3. Job3 ---pulls data from a ODBC connection and loads it into a hash file.
4. Job4 ---pulls data from a ODBC connection and loads it into a hash file.
5. Job5 ---pulls data from a ODBC connection and loads it into a hash file.
6. Job6 ---performs look-ups on all the above hash files using the flat-file (in job1) as the source file.
7. Job7 ---Master sequence which sequencesthe job as below:
Job1-->job2-->Job3-->Job4-->Job5-->Job6
Questions:
1. Will the jobs abort if the source ODBC is down and datastage is not able to access the data files?
2. If the value i'm looking up is not found in the hash file, How can I send this source record to a reject file and simultaneously notify by e-mail?
3. If suppose, the source data has character coming in instead of a numeric, how can I send this to a reject file and again notify by e-mail that these records were rejected?
Please note that it is a windows environment, not UNIX.
Please help me out!
Thanks much,
Naveen.