topic Re: Run SQL files via Scheduler in Alteryx Server Discussions

Run SQL files via Scheduler

bjschwartz3 — Tue, 25 Feb 2020 14:34:53 GMT

I have a ton of old legacy SQL files that I would like to run via Alteryx Scheduler. I rather not remake the file or convert it to Alteryx. I just want Alteryx to run multiple SQL files in succession. Any suggestions on best practices for running multiple SQL files in order via server scheduler?

Re: Run SQL files via Scheduler

hroderick-thr — Wed, 26 Feb 2020 13:31:34 GMT

Most or all databases allow scripts to run from command line.

For example SQL Server has its sqlcmd that's used for it.

Get your scripts running from command line bat file.

Use Alteryx Run Command tool to run the bat files.

Re: Run SQL files via Scheduler

hroderick-thr — Wed, 26 Feb 2020 13:56:01 GMT

p.s. to the reply above:

If you can't use the database's command line tool like sqlcmd, you can write a python program that reads and runs the sql command. Then run the python from Alteryx Run Command tool.