Kettle after timing tasks, and then perform database scripts, always does not perform database scripts, my statement is this:
The first step to perform: kitchen. Bat - rep repository - the user admin - pass admin - dir/directory - job specific tasks - level=basic> Task log. The log
The second step: up sqlplus account/password @ IP/former @ database scripts. Sql> Database scripts log. The log
The two step synthesis of a batch is: kitchen. The bat - rep repository - the user admin - pass admin - dir/directory - job specific tasks - level=basic> Task log. The log
Up sqlplus account/password @ IP/former @ database scripts. Sql> Database scripts log. The log back up sqlplus has been enforced, how to solve, I after the kettle is the purpose of the task has been completed, and then perform database scripts, will perform a complete time record into the database,
How to achieve: kettle after the task has been completed, and then perform database scripts batch, will perform a complete time record into the database, online, etc.,

CodePudding user response:

As far as I know, there is a kind of ETL scheduling monitoring tools TaskCTL, support the kettle is good, can be cross-platform distributed scheduling kettle,
The kettle on Linux/Windows can be adjusted, including automatic timing/schedule, human intervention such as scheduling, as if there were no software can more than it in graphical monitoring, must be much stronger than other monitoring plan,

CodePudding user response:

Everyone a great god himself in the Linux graphical interface run kettle with timer, executed only once stopped, don't know what's reason, passing great god give advice or comments, please, thank you

CodePudding user response:

What controls the execution do you use? There are many ways to achieve it, it's not a SQL script control, can run the SQL paste directly to the above,