Set up of SQL Query in the Management Portal in the IRIS Data Platform

Question

Question

Alicia Watkins · Oct 29, 2021

#Management Portal #SQL #InterSystems IRIS

Hi,

Is there way to set up an automated batch job in the Management Portal to execute an SQL query. Also, how can the related view be exported. I have executed the SQL queries and see the view and created files manually. I could not find any related documentation on the batch processes, but I thought batch or automated jobs could be set up via the Management Portal. Any information is appreciated...

Thanks

Product version: IRIS 2021.1

Discussion (5)1

Log in or sign up to continue

Evgeny Shvarov · Oct 29, 2021

Hi Alicia!

If you want to run some code on schedule (e.g. SQL query) I recommend looking at Task Manager.

Also, there is a handy utility to set up a regular task in IRIS using cron expression programmatically with one line.

0 0

David Hockenbroch · Nov 2, 2021

You'll need the resource %Admin_Task to use task manager functions.

Once you have access to it, set up a class that extends %SYS.Task.Definition and override the OnTask() method. Then you can set it up in the task scheduler and it'll run the OnTask() method according to whatever schedule you set.

0 0

Ben Spead · Dec 1, 2021

Absolutely! You will need to write a method that contains the SQL and then execute the method from a Task. As the linked docs suggest, write your own task by creating a class that extends %SYS.Task.Definition: https://docs.intersystems.com/latest/csp/documatic/%25CSP.Documatic.cls?...

0 0

score 0 · Answer 1 · 2021-11-01T17:24:36-04:00

hi...thank you for this comment....I remember the Task manager in Ensemble, but since we upgraded to IRIS, the System Operation selection is grayed out. I submitted a case to the Vendor to see if I can get access.

Thanks again!

score 0 · Answer 2 · 2021-12-01T16:51:01-05:00

Hi,

Thanks so much for the help. I am able to access the Task Manager. Question, can an SQL query be set up via the Task manager wizard so that it will execute?

Thanks