View all scheduled artefacts in one place?

Follow

Soohan Kim

• February 03, 2017 07:30

As an Admin, is there anyway where I can view all scheduled artifacts in one place?

0

• 

  Konsta Danyliuk

  • February 03, 2017 16:36

  Hi Soohan,

  I believe JobHistory page is exactly what you are looking for, please take a look to our documentation Job History.

  Also I would recommend to walk through our Administration Guide that gives you a lot of information on basic steps of Datameer administration.

  1

  Comment actions Permalink
• 

  Pablo Redondo

  • February 03, 2017 16:38

  I don't believe there is specifically a UI for this, however you can create an import job from your Datameer Metadata and run the following query to get all jobs with owner and schedule. The schedule will appear in cron pattern:

  SELECT DISTINCT
  job_owners.user_name,
  job_owners.df_name,
  job_owners.df_extension,
  djc.id,
  djc.pull_type,
  djc.schedule
  FROM dap_job_configuration djc,
  (
  SELECT df.name df_name, df.extension df_extension, df.id file_id, u.name user_name
  FROM dap_file df, permission p, user u
  WHERE df.permission_fk = p.id
  AND p.owner = u.name
  AND u.name <> 'admin'
  AND df.file_mode = 'NORMAL'
  ) job_owners
  WHERE djc.dap_file__id = job_owners.file_id
  AND djc.pull_type <> 0

  1

  Comment actions Permalink
• 

  Joel Stewart

  • February 03, 2017 17:35

  Hi Soohan, currently there's not a centralized view to check on all the schedules for artifacts that is built into the GUI. On the Job History page of the Admin tab, you can view the history of when jobs were submitted though. This may give you good insight to the historical schedules. 

  1

  Comment actions Permalink

Please sign in to leave a comment.