Monitoring on Failed Scheduled jobs
How can I fetch the details of the Failed Import Schedules using REST API. Kindly suggest if there is any other alternative since I want to integrate the overall failed jobs on Tableau.
-
Hello Deepak.
I hope you are staying safe these days.May I ask you to provide more details on your project, please. Are you interested in all ImportJobs that failed or only those have been triggered automatically at a certain time, or perhaps you are looking for the ImportJobs that have been scheduled but haven't been triggered for some reason?
Thank you in advance.
-
Hi Konsta,
Hope you and your loved one are doing well in these challenging times.
I am looking for all the ImportJobs that were scheduled but failed along with their workbook id. The end goal is to not to check the Emails as to which job failed or didn't execute properly. The same result can be utilized in Tableau to highlight which job failed. I am fairly new to using Datameer so if there is a functionality of using Infographics on Datameer itself would be the best case scenario.
-
Hello Deepak.
There are REST API calls that allow querying an ImportJob's status and its dependencies if any. For example, you could gather the list of ImportJobs IDs you are interested in and build a script that gathers the status of the recent execution of these artifacts.Please refer to the following sections of Datameer documentation for more details.
If you would like to maintain a complete report in Datameer, you could:
- Create MySQL Connection to the Datameer database. Configuring MySQL as a Connection
- Query recent execution status for scheduled ImportJobs together with any other details you require. Importing Data from a Database, How to Create Import Jobs to Import Datameer dap Database Data.
- Create a Workbook with the desired analysis and build an Infographic to display the results. Visualizing Data.
Please sign in to leave a comment.
Comments
3 comments