# Unable to schedule the CData SSIS job in sql server Agent job.

**URL:** <https://community.cdata.com/t/unable-to-schedule-the-cdata-ssis-job-in-sql-server-agent-job/703>\
**Category:** CData Drivers\
**Tags:** sql, question, ssis, workday\
**Created:** [April 26, 2024, 6:25pm UTC](https://community.cdata.com/t/unable-to-schedule-the-cdata-ssis-job-in-sql-server-agent-job/703 "2024-04-26T18:25:06Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Renukachari\_Kasee](https://avatars.discourse-cdn.com/v4/letter/r/ecccb3/32.png) [@Renukachari\_Kasee](https://community.cdata.com/u/Renukachari_Kasee)\
**Post date:** [April 26, 2024, 6:25pm UTC](https://community.cdata.com/t/unable-to-schedule-the-cdata-ssis-job-in-sql-server-agent-job/703/1 "2024-04-26T18:25:07Z")

</div>

Hi [Ethem Q](https://community.cdata.com/members/ethem-q-59),

i have created the ssis package using the CData workday drivers. package is running smoothly when it is in SSIS compailor. and i am trying to schedule this package as agent job in sql server, it is failing with below error. kindly help me in this..

Message  
Executed as user: XXXXXXXXX\RKASEE. Microsoft (R) SQL Server Execute Package Utility &nbsp;Version 15.0.2000.5 for 32-bit &nbsp;Copyright (C) 2019 Microsoft. All rights reserved. &nbsp; &nbsp;Started: &nbsp;2:13:56 PM &nbsp;Error: 2024-04-26 14:15:59.96 &nbsp; &nbsp; Code: 0xC0047062 &nbsp; &nbsp; Source: Workday\_BankAccounts CData Workday Source [609] &nbsp; &nbsp; Description: CData.SSIS.Workday.WorkdayException (0x80004005): [500] Request timed out. Either there is a server issue, or you’ve entered wrong credentials or wrong callback url. ---\> jwo230k.Rx: Request timed out. Either there is a server issue, or you’ve entered wrong credentials or wrong callback url. &nbsp; &nbsp; at jwo230k.FFZ.Ra(Rx ) &nbsp; &nbsp; at jwo230k.FFZ.pg(uNj ) &nbsp; &nbsp; at jwo230k.uPB.K(WP , uNd ) &nbsp; &nbsp; at jwo230k.uPB.G(WP , uTN ) &nbsp; &nbsp; at jwo230k.uPB.kz(uTN , Boolean ) &nbsp; &nbsp; at jwo230k.uTN.q(ucY , uGa , BRG , uGa , uGa , String ) &nbsp; &nbsp; at jwo230k.uTN.c(WP , uGa , BRG , uGa , uGa ) &nbsp; &nbsp; at jwo230k.uNd.s(String , WP , uTl ) &nbsp; &nbsp; at jwo230k.uNd.gp(WP , uTl ) &nbsp; &nbsp; at jwo230k.FjP.pg(uNj ) &nbsp; &nbsp; at jwo230k.uPB.K(WP , uNd ) &nbsp; &nbsp; at jwo230k.uPB.G(WP , uTN ) &nbsp; &nbsp; at jwo230k.uPB.kz(uTN , Boolean ) &nbsp; &nbsp; at jwo230k.ucl.J(ucl , uTN ) &nbsp; &nbsp; at jwo230k.ucl.qa(uTN ) &nbsp; &nbsp; at jwo230k.uPs.G(uTN ) &nbsp; &nbsp; at jwo230k.uPs.r(uPs , uTN ) &nbsp; &nbsp; at jwo230k.uPs.qa(uTN ) &nbsp; &nbsp; at jwo230k.uPs.qa(uTN ) &nbsp; &nbsp; at jwo230k.uGE.OI(uTN ) &nbsp; &nbsp; at jwo230k.EZ.m(uNj , vO ) &nbsp; &nbsp; at jwo230k.EZ.V(uNj , vO , ulu ) &nbsp; &nbsp; at jwo230k.BxR.kv() &nbsp; &nbsp; at jwo230k.Bxu.kv() &nbsp; &nbsp; at jwo230k.lB.m(Int32 , Object , ulu , Int32 , hk ) &nbsp; &nbsp; at jwo230k.lB.G(Int32 ) &nbsp; &nbsp; at jwo230k.lB.H(Boolean ) &nbsp; &nbsp; at jwo230k.lB.x(xp , Boolean , Boolean , sx ) &nbsp; &nbsp; at jwo230k.lB.o(hk ) &nbsp; &nbsp; at jwo230k.hE.Connect() &nbsp; &nbsp; at jwo230k.BOO.Connect() &nbsp; &nbsp; at jwo230k.Pq.qV() &nbsp; &nbsp; at jwo230k.Pq.qg() &nbsp; &nbsp; at jwo230k.Pq.pf() &nbsp; &nbsp; at jwo230k.PE.pf() &nbsp; &nbsp; at jwo230k.Ps.Acquire(String , String , ulu ) &nbsp; &nbsp; at jwo230k.TY.Open() &nbsp; &nbsp; at jwo230k.aqZ.Open() &nbsp; &nbsp; at jwo230k.aqZ.Open() &nbsp; &nbsp; at CData.SSIS.Workday.WorkdayConnMgr.AcquireConnection(Object txn) &nbsp; &nbsp; at Microsoft.SqlServer.Dts.Runtime.ManagedWrapper.AcquireConnection(Object txn) &nbsp; &nbsp; at Microsoft.SqlServer.Dts.Runtime.ConnectionManager.AcquireConnection(Object txn) &nbsp; &nbsp; at jwo230k.FcO.AcquireConnections(Object ) &nbsp; &nbsp; at Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostAcquireConnections(IDTSManagedComponentWrapper100 wrapper, Object transaction) &nbsp;End Error &nbsp;Error: 2024-04-26 14:15:59.96 &nbsp; &nbsp; Code: 0xC0047017 &nbsp; &nbsp; Source: Workday\_BankAccounts SSIS.Pipeline &nbsp; &nbsp; Description: CData Workday Source failed validation and returned error code 0x80004005. &nbsp;End Error &nbsp;Error: 2024-04-26 14:15:59.96 &nbsp; &nbsp; Code: 0xC004700C &nbsp; &nbsp; Source: Workday\_BankAccounts SSIS.Pipeline &nbsp; &nbsp; Description: One or more component failed validation. &nbsp;End Error &nbsp;Error: 2024-04-26 14:15:59.96 &nbsp; &nbsp; Code: 0xC0024107 &nbsp; &nbsp; Source: Workday\_BankAccounts &nbsp; &nbsp; &nbsp;Description: There were errors during task validation. &nbsp;End Error &nbsp;DTExec: The package execution returned DTSER\_FAILURE (1). &nbsp;Started: &nbsp;2:13:56 PM &nbsp;Finished: 2:15:59 PM &nbsp;Elapsed: &nbsp;123.438 seconds. &nbsp;The package execution failed. &nbsp;The step failed.

---

<div class="post-metadata">

**Author:** ![Ethem\_Q](https://sea3.discourse-cdn.com/cdata/user_avatar/community.cdata.com/ethem_q/32/1997_2.png) [@Ethem\_Q](https://community.cdata.com/u/Ethem_Q)\
**Post date:** [April 26, 2024, 10:32pm UTC](https://community.cdata.com/t/unable-to-schedule-the-cdata-ssis-job-in-sql-server-agent-job/703/2 "2024-04-26T22:32:12Z")

</div>

Hi @Renukachari_Kasee

The issue you are seeing is due to the OAuth process failing to complete. It is most likely happening because the browser is trying to launch but it is failing to start under the SQL Server Agent. Please note that the SQL Server Agent can only access public paths.&nbsp;  
&nbsp;&nbsp;  
To fix this, you should copy the OAuthSettings.txt file from ‘C:\Users\User\AppData\Roaming\CData\Workday Data Provider’ to a public path (e.g., ‘C:\Users\Public\Documents’) and then set the OAuth Settings Location in your connection settings to this new path in the connection configuration.

In case you encounter any other issues feel free to reach out to our support team at [support@cdata.com](mailto:support@cdata.com).