topic Re: Executing A Talend Job Using Windows Scheduler in Talend Studio

Executing A Talend Job Using Windows Scheduler

Anonymous — Wed, 05 Dec 2012 03:21:40 GMT

Hi,
I created several design Jobs using Talend open studio 5.2.0M3
I want to schedule the job that i created using Windows Scheduler.
I try to export my job but a .bat file not there.
Anyone know to solve this

Thank you

Re: Executing A Talend Job Using Windows Scheduler

Anonymous — Wed, 05 Dec 2012 03:43:14 GMT

Hi,
Which way do you chose to export your job? select root directory or select archive file? We double that the process of exporting your job is not successful.
Best regards
Sabrina

Re: Executing A Talend Job Using Windows Scheduler

Anonymous — Wed, 05 Dec 2012 06:43:57 GMT

Hi Sabrina,
i select archive file when do the export job.
i use open source TOS_DI v5.2.0m3

Regards,
Mie

Re: Executing A Talend Job Using Windows Scheduler

Anonymous — Wed, 05 Dec 2012 07:11:43 GMT

Hi,
If you want to get a .bat file, you cannot choose "Export items" but the "Export job" option instead. see pics.
Best regards
Sabrina

Re: Executing A Talend Job Using Windows Scheduler

Anonymous — Wed, 05 Dec 2012 09:25:55 GMT

Hi Sabrina,
It work!! i select the export type : Axis webservice (ZIP) previously. Now it work.
Tq!

Re: Executing A Talend Job Using Windows Scheduler

Anonymous — Wed, 05 Dec 2012 09:37:51 GMT

Hi,
Well, good news and thanks for your feedback!
Best regards
Sabrina

Re: Executing A Talend Job Using Windows Scheduler

_AnonymousUser — Fri, 14 Dec 2012 21:35:18 GMT

Hi,
I am trying to use windows scheduler to run the batch file generated by exporting my job in Talend
The scheduler in windows kicks off the batch file but the job in talend doesnt actually run. When i run the job from Talend it runs perfectly.
What might be the reason.
Iam using using Talend open studio 5.2.0
Thank you

Re: Executing A Talend Job Using Windows Scheduler

Anonymous — Mon, 17 Dec 2012 07:06:07 GMT

Hi, Prash
I have executed a Talend Job using Windows Scheduler in TOS 5.2.0, and it works well! How do you set your Windows Scheduler? I upload my screenshots to you, hope it will help you! In addition that, giving you some info about Windows
Scheduler http://www.iopus.com/guides/winscheduler.htm

Best regards
Sabrina

Re: Executing A Talend Job Using Windows Scheduler

_AnonymousUser — Mon, 17 Dec 2012 21:39:04 GMT

Hi xdshi
I tried the same steps mentioned above but couldnt get the job running in Talend.
I have the last run time for Job in the scheduler window but the job did not actually run in Talend.
The job exported is used to update tables in oracle and mysql databses.
What might be the reason ?
Thanks
Prash

Re: Executing A Talend Job Using Windows Scheduler

Anonymous — Tue, 18 Dec 2012 01:55:54 GMT

Hi,

I tried the same steps mentioned above but couldnt get the job running in Talend.
I have the last run time for Job in the scheduler window but the job did not actually run in Talend.

You may make a misunderstanding about that job did not actually run in Talend instead in your command window. Because the job has been exported from Talend, it has none business with Talend unless you run it in Talend.
Best regards
Sabrina

Re: Executing A Talend Job Using Windows Scheduler

Anonymous — Tue, 18 Dec 2012 11:19:06 GMT

one quick question, can a window's scheduler execute a job without displaying a command prompt on the screen. Like I have scheduled a job to load a file,
tfileInput --- > iFileOutput
|
|
on subjob ok
|
|
tmsgbox(display's a file time of load)

i want only that msgbox to display , which prompt only file load status with time no command prompt display.
thanks

Re: Executing A Talend Job Using Windows Scheduler

Anonymous — Wed, 19 Dec 2012 08:49:48 GMT

Hi,
The msgbox can display, and you don't need input a command prompt on the screen. See pic2, is that what you need?
Best regards
Sabrina

Re: Executing A Talend Job Using Windows Scheduler

Anonymous — Thu, 20 Dec 2012 04:55:10 GMT

HI
may be my explanation was wrong, what i need is only to display the message box not command prompt but the above screen shot is showing command prompt and msgbox. And i have scheduled a job in windows scheduler

thanks in advance

Re: Executing A Talend Job Using Windows Scheduler

Anonymous — Thu, 20 Dec 2012 07:12:57 GMT

Hi,
Well, it is not the business of Windows Scheduler but the .bat file. If you run the .bat file in your computer, the command prompt will pop up. I have no idea, sorry about that.
Best regards
Sabrina

Re: Executing A Talend Job Using Windows Scheduler

Anonymous — Mon, 14 Jan 2013 03:02:45 GMT

hi Sabrina,
I have a job that I exported as .bat file. When I execute the .bat file using window service it did not work.
Do you have any idea what is the problem?
Attached is the screen shot of the job that I exported as .bat file.
Thanks in advance.
Regards,
naim

Re: Executing A Talend Job Using Windows Scheduler

Anonymous — Mon, 14 Jan 2013 03:54:15 GMT

Hi,

When I execute the .bat file using window service it did not work.

Your job work well from the screenshot, but I have a little confusion what' s your meaning "it did not work"? When you execute the .bat file using window service, nothing happened to you?or you don't see the result? do you set the key word"pause" into your .bat file so that you can see the window console? Waiting for your response.
BTW, Please read this page on Talend Help Center to know more about how to import/export job item or jobs
https://help.talend.com/pages/viewpage.action?pageId=3975139
Best regards
Sabrina

Re: Executing A Talend Job Using Windows Scheduler

Anonymous — Mon, 14 Jan 2013 04:00:32 GMT

Hi,
What I mean with the meaning of "it did not work" is that the data did not load into the database. I used the .bat file as the platform.
On the other hand, the job works when I used Talend as the platform to execute the job.
Regards,
naim

Re: Executing A Talend Job Using Windows Scheduler

Anonymous — Mon, 14 Jan 2013 08:09:47 GMT

Hi,
I got your issue, but we need take a testing on it. I suspect something wrong with the target DB and we will give you the response asap.
Best regards
Sabrina

Re: Executing A Talend Job Using Windows Scheduler

Anonymous — Tue, 15 Jan 2013 01:16:56 GMT

Hi Sabrina,
Thank you so much for your help.
Regards,
naim

Re: Executing A Talend Job Using Windows Scheduler

Anonymous — Tue, 15 Jan 2013 03:38:12 GMT

Hi,
We have a discussion about your issue and give you the result.
First of all, you should run your .bat file by window command line. Right click and select the "Run as administrator" to check if your job work well? If so, the .bat file is totally correct.

using window service it did not work.

Something wrong with your configuration of window service not the job. You don't trigger it which cause you cannot get the result your expected.
Unfortunately, we never use window service to start it before, Mr. Goole will help you. Sorry about that.
Don't hesitate to post issue on Talend forum, i will try my best to help you.
Best regards
Sabrina