EDG Scheduler

[Peter Philips]

Hi team,

As a function of Scheduling Jobs in EDG, we have a use case for being able to view upcoming jobs that are scheduled to run, and viewing the state of previously run scheduled job in EDG (using the scheduler/automation scripting).

The team let me know there is limited out-of-the-box support for viewing previously run and pending scheduling jobs. We wanted to ask if there's available guidance on creating these particular views or any examples of these views (like a calendar view). If this is possible with a potential tab or an 'admin view' to allow inspection of jobs and even including potential manipulation of schedules, we'd like some guidance from TQ, and/or pointing to to available resources to assist with building these views/functions.

Kind Regards,

Peter

[Richard Cyganiak]

Hi Peter,

A possible approach for reporting on past job executions would be:

1. Create a data graph asset collection (or custom asset collection type) such as “Job Execution Log”

2. Modify the job so that it updates this asset collection and inserts desired information about its execution

3. Devise SPARQL or GraphQL queries to retrieve this information in an appropriate format

4. Use your preferred front-end development technology to create a view based on these query results; this could be a view inside EDG, or an external application that queries EDG via the SPARQL/GraphQL endpoints

A possible approach for reporting on upcoming job executions would start with this SPARQL query which uses the teamwork:scheduledJobStatus property function:

    PREFIX teamwork: <http://topbraid.org/teamwork#>

    SELECT * {

      ?job teamwork:scheduledJobStatus (?schedule ?nextFireTime ?currentExecutionId ?currentExecutionDurationMs ?schedulingUser)

    }

1. The SPARQL query returns currently defined jobs including their cron schedule expression and each job's next fire time

2. Devise a way to calculate future execution times from the cron expression. We don't have any APIs that help with this beyond the ?nextFireTime above.

3. Use your preferred front-end development technology to create a view based on the SPARQL query results; this could be a view inside EDG, or an external application that queries EDG via the SPARQL/GraphQL endpoints

Manipulating the schedule of upcoming executions is not possible, with the exception of triggering a job execution right now, and modifying the cron expression for user-scheduled jobs.

I don't have the skills to advise on front-end questions like calendar views etc.

Richard

--
You received this message because you are subscribed to the Google Groups "TopBraid Suite Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to topbraid-user...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/topbraid-users/6e7a63f3-e1f7-453f-8d7b-d71554463d3cn%40googlegroups.com.

[Holger Knublauch]

Just adding a few suggestions, in case using EDG itself for the UI would be sufficient:

On 2022-03-29 8:13 pm, Richard Cyganiak wrote:

Hi Peter,

A possible approach for reporting on past job executions would be:

0. Define an ontology to represent the execution log, e.g. a class such as ex:ExecutedJob

1. Create a data graph asset collection (or custom asset collection type) such as “Job Execution Log”

2. Modify the job so that it updates this asset collection and inserts desired information about its execution

e.g. create instances of ex:ExecutedJob with a timeStamp property

3. Devise SPARQL or GraphQL queries to retrieve this information in an appropriate format

4. Use your preferred front-end development technology to create a view based on these query results; this could be a view inside EDG, or an external application that queries EDG via the SPARQL/GraphQL endpoints

e.g. use the Search panel of EDG itself to look at instances of ex:ExecutedJob, sorted by timeStamp or filtered by other properties.

Holger

A possible approach for reporting on upcoming job executions would start with this SPARQL query which uses the teamwork:scheduledJobStatus property function:

    PREFIX teamwork: <http://topbraid.org/teamwork#>

    SELECT * {

      ?job teamwork:scheduledJobStatus (?schedule ?nextFireTime ?currentExecutionId ?currentExecutionDurationMs ?schedulingUser)

    }

1. The SPARQL query returns currently defined jobs including their cron schedule expression and each job's next fire time

2. Devise a way to calculate future execution times from the cron expression. We don't have any APIs that help with this beyond the ?nextFireTime above.

3. Use your preferred front-end development technology to create a view based on the SPARQL query results; this could be a view inside EDG, or an external application that queries EDG via the SPARQL/GraphQL endpoints

Manipulating the schedule of upcoming executions is not possible, with the exception of triggering a job execution right now, and modifying the cron expression for user-scheduled jobs.

I don't have the skills to advise on front-end questions like calendar views etc.

Richard

On 29 Mar 2022, at 03:34, Peter Philips <peter....@surroundaustralia.com> wrote:

Hi team,

As a function of Scheduling Jobs in EDG, we have a use case for being able to view upcoming jobs that are scheduled to run, and viewing the state of previously run scheduled job in EDG (using the scheduler/automation scripting).

The team let me know there is limited out-of-the-box support for viewing previously run and pending scheduling jobs. We wanted to ask if there's available guidance on creating these particular views or any examples of these views (like a calendar view). If this is possible with a potential tab or an 'admin view' to allow inspection of jobs and even including potential manipulation of schedules, we'd like some guidance from TQ, and/or pointing to to available resources to assist with building these views/functions.

Kind Regards,

Peter

--
You received this message because you are subscribed to the Google Groups "TopBraid Suite Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to topbraid-user...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/topbraid-users/6e7a63f3-e1f7-453f-8d7b-d71554463d3cn%40googlegroups.com.

--
You received this message because you are subscribed to the Google Groups "TopBraid Suite Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to topbraid-user...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/topbraid-users/FAFD19AA-8A20-4EF8-8980-ACE2F6F30A09%40topquadrant.com.

[Peter Philips]

Thank you Richard and Holger,

The advice is very helpful.

Kind Regards,

Peter