By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
464,773 Members | 1,019 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 464,773 IT Pros & Developers. It's quick & easy.

Automation for the kickoff of jobs

P: 1
Hi,

I have two process one is SAS process and an ETL process.While running the SAS process the ETL process is onhold(OH).As soon as the process finishes the ETL process has to be started which is currently done by the manual intervention.

What i need is to automate the ETL process in such a way that as soon as the SAS process finishes this ETL has to to start(Auto), based on a condition which gives the status of SAS process.

Could you please let me know how to code the script as well give me an example.

Thanks&Regards,
Mansur.
Oct 18 '07 #1
Share this Question
Share on Google+
1 Reply

Motoma
Expert 2.5K+
P: 3,237
Hi,

I have two process one is SAS process and an ETL process.While running the SAS process the ETL process is onhold(OH).As soon as the process finishes the ETL process has to be started which is currently done by the manual intervention.

What i need is to automate the ETL process in such a way that as soon as the SAS process finishes this ETL has to to start(Auto), based on a condition which gives the status of SAS process.

Could you please let me know how to code the script as well give me an example.

Thanks&Regards,
Mansur.
How do you administer these right now? By the command line?
I think what you will want to do is capture the exit code from the SAS process, examine that in your script, and make calls to your ETL process.
Oct 18 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.