Talend Job executed via SQL Server Agent

[Anonymous]

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?

[Anonymous]

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.

[Anonymous]

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)

[Anonymous]

Hi
I have replied you in your another topic.