You are not logged in.
Announcement
Unanswered posts
|
Pages: 1

Hi,
I want to make a replication between two distant MySQL databases automatically: it means that I want to have an automatical execution of the replication job one time every day at a specific time.
Could you help me solve this issue? It is really urgent.
Thank you very much!
Best regards,
Nizar,
Offline
Hi
Please search 'scheduler' on forum, there are many related topics.
Best regards
Shong
Offline

Hi
You can export the job i.e in jar, put it in a scheduler and run it.
Offline

Hi
Sorry batch file, not jar..
Right click on a job and select Export job scripts. This will give u a zip file. Extract the folder. For Example, if your job name is A1.0. Once extracted it will generate two folders inside A1.0 (A1.0 and lib). In the A1.0 sub folder you can see a batch file. You can schedule that batch file.
Scheduler
You can use windows scheduler, I am using a solway's task scheduler.
Hope this helps you
Offline

Hi,
With windows scheduler, if everything is ok, there is no problem; but if there is an error, what happens? does the execution be interrupted? and where can we see the errors generated?
Thanks for all,
Best regards,
Nizar.
Offline

Hi
It depends on your job designing. If you are writing into a file, where there is any error then that will work.
ie innner join rejected rows of tJoin into a log file
Other wise , one easy solution is A1.bat>> c:\log.txt. this is not an optimal solution.
Offline

Hi,
In fact, my job design is: tMysqlInput >> tMysqlOutput.
I have exported my job (a batch file) and scheduled its execution once a day with Windows Task Scheduler.
So, is it possible to get the errors when the execution fails and how?
Best regards,
Nizar.
Offline

Hi
Use tMysqlOutput->rejects also, if rejected point to an output txt file writing the error i.e
tMysqlOutput _____rejects_____>tMap->tOutputDelimited
This write the error into a file.
Offline

Hi
Sorry its tFileOutputdelimited
its in File-> Output palette section
Offline

Hi,
I made as lijo told me: tMysqlInput > tMysqlOutput > tMap > tFileOutputDelimited
but I find nothing written in the file out.csv when an error happens!
Could you help me solve this issue? Which kind of errors are written in the file...?
Thank you!
Best regards,
Nizar
Offline

Hi
The normal errors will be mostly database specific errors. It will not catch the exceptions.
i hope you are giving tMysqlOutput __Rejects__->tMap
Offline
Pages: 1