Scheduler not working

[jstewart]

Hello, 

My subject is vague but so is my problem. When i try to schedule a job, usually I test a minute or two after current time, nothing happens and there are no errors triggered but it works as is within designer. The workflow is the following, connected to a sql database, create points, export .shp on a shared drive using UNC path, and email said files. I am choosing to run original location on disc w/in the scheduler and I have also set settings to run as a different user (which is me) as suggested from other posts. My current thought is when I chose test in workflow dependencies, the instance related to my sql connection becomes red but no other info is provided. 

Can anyone help with this?

Cheers, 

Jack

[AmeliaG]

Hi @jstewart,

If your SQL connection is a user DSN or is using Windows Auth, you will need to set a 'Run As' user with your credentials. To do so, follow the instructions here.

Thanks,

Amelia

[jstewart]

Amelia, 

Thanks for the suggestion but I have already done this as mentioned in my post. One error however that I am not fully understanding is when testing my workflow dependencies my sql connection comes back with, "Format of the initialization string does not conform to specification starting at index 0.".

Thanks, 

Jack 

[AmeliaG]

Hi @jstewart,

Hm that is interesting. Can you show me an example of what your SQL connection looks like in workflow dependencies?

Thanks!

Amelia