JOD / Job on demand alternative

JOD / Job on demand alternative

Joined: February 9th, 2004, 10:10 am

January 6th, 2017, 3:20 pm #1

Dear gurus,

At my client we are currently using a JOD or "job on demand" interface which a set of bat that include the [in]famous CHOICE command. The JOD is executed from a shared directory and a scheduling triggers the selected actions (bat executes maxl and so on).

Choice is better than nothing and I must admit that it gives good interaction with system (bat, maxl etc.) however it is awful and error prone as some of our batch do more than 3000 row.

What would be the alternatives around? I was thinking indeed about a kind of web template or framework to build this kind of task and workflow but sure I must be dreaming!..
Quote
Like
Share

Joined: April 4th, 2008, 8:06 pm

January 6th, 2017, 3:57 pm #2

Hi SR,

We are using RunDeck at one of our clients and seems to be working well presuming you architect it properly e.g. don't simply run a job over and over every 2 seconds and instead ensure it can do trigger file detection.

See http://rundeck.org/

We have an automation/monitoring product on the drawing board as well however it's probably 6 months from seeing something we want to showcase.

Kind Regards,

John A. Booth
http://www.metavero.com
Quote
Like
Share

Pete
Pete

January 7th, 2017, 7:08 am #3

We've got a client with Control-M and they talk very highly of it.

Gives you a gui and what not.

I'm going to do a bit of work with it to trigger some of the PBCS processes (which are all written in batch \ powershell) - but I've not done anything yet, so YMMV.
Quote
Share

Joined: April 4th, 2008, 8:06 pm

January 7th, 2017, 2:33 pm #4

Hi Pete,

I assumed SR didn't have one of the enterprise job schedulers readily available.

For a more full list of job schedulers see https://en.wikipedia.org/wiki/List_of_j ... r_software

Now the above list may be a bit dated.

Also see:
https://blog.profitbricks.com/48-best-c ... utomation/

A lot of the tools they show in above list are for configuring and deploying versus a scheduler.

Kind Regards,

John A. Booth
http://www.metavero.com
Quote
Like
Share

Anonymous
Anonymous

January 7th, 2017, 4:05 pm #5

Warning guys we have an enterprise scheduler already (tivoli) but this is not the point here.
I am looking for an industrial way of building an interface for end users to manage workflow and jobs in link with essbase (bat and maxl) and business process.
I want to build a workflow as I would do with the dos choice command were users may select a process through lists then it triggers the related job/bath/script...
It has nothing to do with enterprise scheduler that we use for regular/cyclic tasks.
Quote
Share

Pete
Pete

January 9th, 2017, 5:22 am #6

Does tivoli have a front end you could expose to users for manually triggered jobs? Or is it purely a scheduler?

I'm honestly not sure what the middle ground is here. If you had planning I'd say just move everything into Tasklists, with CDF based business rules (see Celvin and John Booth's work for literally doing anything you wanted via CDF to Groovy or CDF to Batch to Powershell to Rest API).

Without already having a web front end like Planning - you could write your own (Java maybe), but the scalability (particularly building a web front end that is integrated into user security and access etc etc) would seem to be more trouble than it's worth.

What are you trying to actally have users run?

Quote
Share

Cameron Lackpour
Cameron Lackpour

January 9th, 2017, 1:18 pm #7

>>...it is awful and error prone as some of our batch do more than 3000 row.
^^^Indeed, that sounds pretty awful.

>>What are you trying to actally have users run?
^^^Yes, what?

Seriously, this has to be some kind of (dubious) record. Why on earth are *users* kicking processes off like that? Does something that complex make any sense from a user perspective? Isn't that something better suited for administrators?

I know there's a range of tolerance for KISS vs. needs-must-when-the-devil-drives but good grief, 3000 lines of batch code?

http://www.retroist.com/2013/11/02/nati ... y-crusher/

Regards,

Cameron Lackpour
Quote
Share

Kevin Cox
Kevin Cox

January 9th, 2017, 3:21 pm #8

Dear gurus,

At my client we are currently using a JOD or "job on demand" interface which a set of bat that include the [in]famous CHOICE command. The JOD is executed from a shared directory and a scheduling triggers the selected actions (bat executes maxl and so on).

Choice is better than nothing and I must admit that it gives good interaction with system (bat, maxl etc.) however it is awful and error prone as some of our batch do more than 3000 row.

What would be the alternatives around? I was thinking indeed about a kind of web template or framework to build this kind of task and workflow but sure I must be dreaming!..
I'm not sure why it all has to run through one job and branch out via user input. The fact that Essbase users are interacting with the innards of a batch file seems error prone.

I have a number of user-initiated jobs that are built as follows...

* MaxL written to interact with Essbase
* Batch written to execute MaxL shell/script

* CDF "RunExe" installed, which allows the running of a batch file from a CDF command in a calc script
* Numerous Calc Scripts that each contain a RunExe mention of a batch file

Grant Calc Script execution for these Calc Scripts to the interested users. Users can then do this work as if it were another calculation, and they can do it via Smart View, Workspace, etc.

For those interested, these tasks do simple things that are file based, such as export, copy, import plan from disparate databases to a central database...but on demand.

Good Luck!
Kevin
Quote
Share

Joined: April 4th, 2008, 8:06 pm

January 9th, 2017, 3:39 pm #9

>>...it is awful and error prone as some of our batch do more than 3000 row.
^^^Indeed, that sounds pretty awful.

>>What are you trying to actally have users run?
^^^Yes, what?

Seriously, this has to be some kind of (dubious) record. Why on earth are *users* kicking processes off like that? Does something that complex make any sense from a user perspective? Isn't that something better suited for administrators?

I know there's a range of tolerance for KISS vs. needs-must-when-the-devil-drives but good grief, 3000 lines of batch code?

http://www.retroist.com/2013/11/02/nati ... y-crusher/

Regards,

Cameron Lackpour
Makes you wonder if it's a cobbled together planning process because of lack of business rules or other glue such as Dodeca, Planning, ... on top of Essbase or some type of ASO allocations strung together as a poor mans profitability setup.

Kind Regards,

John A. Booth
http://www.metavero.com
Quote
Like
Share

Joined: February 9th, 2004, 10:10 am

January 10th, 2017, 7:08 pm #10

Well it is not so complicated to understand as we don't use planning. For instance during rolling forecast user select input phase, RF month, scenario initialization etc.. so one has to go through various selection screens that feed variables, substitution variables and at last trigger calc scripts! That's it! Sure that with Dodeca or a dedicated interfaced it would be nicer and easier.
Quote
Like
Share


Confirmation of reply: