Talend Job executed via SQL Server Agent

One Star

Talend Job executed via SQL Server Agent

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?
Community Manager

Re: Talend Job executed via SQL Server Agent

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.
----------------------------------------------------------
Talend | Data Agility for Modern Business
One Star

Re: Talend Job executed via SQL Server Agent

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)
Community Manager

Re: Talend Job executed via SQL Server Agent

Hi
I have replied you in your another topic.
----------------------------------------------------------
Talend | Data Agility for Modern Business