Item: JAMS
Rating: 10
Author: Paul Ulici

Use Cases and Deployment Scope

We schedule various jobs to run based on all sorts of dependencies and sequences using JAMS, mostly automation of extracts, data imports, and data manipulation jobs.

Pros and Cons

Schedules pretty much any type of job SQL, Powershell, Other applications, and Workflows.
Encryption/decryption.
Monitoring of job statuses.
Alerts when things go wrong.
Automated retries.

Document the REM statement a little better; it took me quite a bit of digging to figure it out and would be better if one could use standard comment characters like in other languages (although with Powershell scripts, the Powershell one works ok.
It's important to comment on the code in the source tab especially when changes happen, and you want to keep track of historical changes.

Return on Investment

I think it helps with automation and catching issues early with notifications.

Yes, they have been extremely helpful whenever I have called and connected with them, particularly in helping me figure out how encryption/decryption workflows work and solving even minor issues I couldn't find the answer to. Ian and Jeff have been very helpful with creating and troubleshooting workflows that are a pain to figure out because of security limitations (permissions, etc.).

Key Insights

Do you think JAMS delivers good value for the price?

Yes

Are you happy with JAMS's feature set?

Yes

Did JAMS live up to sales and marketing promises?

Yes

Did implementation of JAMS go as expected?

I wasn't involved with the implementation phase

Would you buy JAMS again?

Yes

Other Software Used

Microsoft Visual Studio, Oracle Database

Likelihood to Recommend

The automation of jobs with JAMS is great.

JAMS has been working well for us. A few hiccups here and there but there is noticeable improvement.

Overall Satisfaction with JAMS