I have 42 datastage jobs need to be scheduled one after another using Datastage Director and add an email notification. Can anyone help me doing this.
What I did so far is I added 42 Job activity stages in a Sequence Job but I want it to make little simple.
Thank you.
Scheduling using Datastage Director
Moderators: chulett, rschirm, roy
What you've got is pretty simple. Clarify something for us - when exactly do you need to send this email notification and what is its purpose? Is it just one after all jobs have been run, or one after every job completes? Or is it just for error notification?
Do you want something more... "flexible"? Say where the number or collection of jobs to run can change over time? There are ways to manage that (especially if they can all be run in a serial fashion) depending on how creative you want to be and what other silly restrictions you have on you like no shell scripts.
Do you want something more... "flexible"? Say where the number or collection of jobs to run can change over time? There are ways to manage that (especially if they can all be run in a serial fashion) depending on how creative you want to be and what other silly restrictions you have on you like no shell scripts.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
I just want one email notification for all jobs at the end with all the job details(Failed/Okay).
The number of jobs may not change and I scheduled in serial so far and trigger with unconditional as they are not dependent.
I understand the shell script permission. The server has high sensitive data.
The number of jobs may not change and I scheduled in serial so far and trigger with unconditional as they are not dependent.
I understand the shell script permission. The server has high sensitive data.
Then what you've got should be fine. I was thinking a loop but it doesn't sound like it would buy you all that much. And we have sensitive data on our servers but that doesn't preclude the use of scripts, it just means that any we use have be 'hardened' against mischief and pass a security audit. For whatever that is worth.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers