More fine tuned controls for sql statements

[jonnyz32]

Options for

• Whether we want statements to be executed in transaction
• Should we rollback batch operations if anything fails
• Autocommit

[worksofliam]

I believe auto commit can be controlled in the job connection properties.