Is is possible to query the job dependencies

Follow

0

Rudolf Van der Heide

• March 04, 2024 09:57

Hi all,

I'd like to query the job dependencies to do a bit more extensive analysis than possible in the job screen. 

Is there a way to do that? 

• 0

  Comment actions Permalink

  

  Hrant Kocharyan

  • March 14, 2024 08:24

  Hi Rudolf,
  
  Joining "SYSADMIN.ScheduleJobs" and "SYSADMIN.Schedules" is a good starting point.
  Please have a look at this query. It should give you an idea how to proceed with your analysis. 

  SELECT
      "ScheduleJobs.jobName",
      "ScheduleJobs.Description",
      "Schedules.id",
      "Schedules.jobID",
      "Schedules.type",
      "Schedules.intervl",
      "Schedules.startDelay",
      "Schedules.cronExpression",
      "Schedules.enabled",
      "Schedules.chainString",
      "Schedules.nextFireTime",
      "Schedules.performedRetries",
      "Schedules.creationDate",
      "Schedules.lastModifiedDate",
      "Schedules.creator",
      "Schedules.modifier",
      "Schedules.scheduleName",
      "Schedules.queueHandler",
      "Schedules.owner",
      "Schedules.uuid"
  FROM 
      "SYSADMIN.ScheduleJobs" INNER JOIN "SYSADMIN.Schedules" ON "ScheduleJobs.id" = "Schedules.jobID";;

  Let me know if you have any other questions. I'll be happy to help!
  
  Thanks,
  Hrant

Please sign in to leave a comment.