Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

MySql error when scheduled

david20100
8 - Asteroid

HI,

 

If i run my Mysql workflow everything is OK.  If i scheduled the same workflow, cannot run.  (MySQL query: Select * From TempsEmployeJour Where TempsEmployeJour.date_trx >= '2015-08-28' And TempsEmployeJour.date_trx <= '2018-08-25' )

 

Thanks

 

MySql.JPGMySQL2.JPGDB.JPG

1 REPLY 1
CharlieS
17 - Castor
17 - Castor

Looks like you've got it set up as a User DSN and not a system DSN. Depending on your IT policies, the easiest route might be to set the Alteryx Service to use your user credentials. 

 

https://community.alteryx.com/t5/Alteryx-Server-Knowledge-Base/Run-As-Settings/ta-p/17830

 

 

Labels