Talend Job executed via SQL Server Agent

Anonymous — Thu, 13 Sep 2012 15:59:29 GMT

Can a talend job be executed via a SQL Server Job agent? We would also need to do this from within a stored procedure. Is this possible?

Re: Talend Job executed via SQL Server Agent

Anonymous — Fri, 14 Sep 2012 04:59:34 GMT

Hi
I think it is possible. Talend job can be exported as a job script, it is a bat file, and you call this bat file in a stored procedure.

Re: Talend Job executed via SQL Server Agent

Anonymous — Wed, 17 Oct 2012 19:44:38 GMT

Hi Shong,
I have developed a Talend job which is working fine in my local system.I have exported it on another system and trying to call .bat file using sql agent and end up having following error. I am using MS Access .mdb file in talned job
Error Message as below
C:\WINDOWS\system32>pushd \\INFO-DEV01\jobs\Job4OCKidsExtract_0.1\Job4OCKidsExtract\
Y:\Job4OCKidsExtract_0.1\Job4OCKidsExtract>java -Xms256M -Xmx1024M -cp classpath.jar; ohm.job4ockidsextract_0_1.Job4OCKidsExtract --context=Default
Exception in component tAccessRow_1
java.sql.SQLException: Data source name not found and no default driver specified
at sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source)
at sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source)
at sun.jdbc.odbc.JdbcOdbc.SQLDriverConnect(Unknown Source)
at sun.jdbc.odbc.JdbcOdbcConnection.initialize(Unknown Source)
at sun.jdbc.odbc.JdbcOdbcDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at ohm.job4ockidsextract_0_1.Job4OCKidsExtract.tAccessRow_1Process(Job4OCKidsExtract.java:710)
at ohm.job4ockidsextract_0_1.Job4OCKidsExtract.tFixedFlowInput_1Process(Job4OCKidsExtract.java:650)
at ohm.job4ockidsextract_0_1.Job4OCKidsExtract.runJobInTOS(Job4OCKidsExtract.java:3860)
at ohm.job4ockidsextract_0_1.Job4OCKidsExtract.main(Job4OCKidsExtract.java:3752)

Re: Talend Job executed via SQL Server Agent

Anonymous — Thu, 18 Oct 2012 07:28:25 GMT

Hi
I have replied you in your another topic.

topic Re: Talend Job executed via SQL Server Agent in Talend Studio

Talend Job executed via SQL Server Agent

Re: Talend Job executed via SQL Server Agent

Re: Talend Job executed via SQL Server Agent

Re: Talend Job executed via SQL Server Agent