Task: equi-join-detect (source dataset: Auto-BI)

Your are given a database with related tables used for business intelligence analysis. Your task is to identify all key/foreign-key join relationships between the tables for this database. Recall that a join is a relationship between two tables, that allows rows from one table to be combined with rows from another, based on a set of common join columns.
 
 
No explanation needed. Please return all join relationships in the following JSON format:
{
  "joins": [
    {
      "from_table": "table-1",
      "from_column": "column-1",
      "to_table": "table-2",
      "to_column": "column-3"
    }, 
	...
  ]
}

Tables:

Table: Job History
| JobName                                                      |   Step | StepName                                                                            | RunDateTime             |   RunDurationSeconds |   RunDurationMinutes |   retries_attempted |   enabled | job_id                               | message                                                            | EnabledStatus   | category_name           |
|:-------------------------------------------------------------|-------:|:------------------------------------------------------------------------------------|:------------------------|---------------------:|---------------------:|--------------------:|----------:|:-------------------------------------|:-------------------------------------------------------------------|:----------------|:------------------------|
| sysutility_get_cache_tables_data_into_aggregate_tables_daily |      2 | Purge cache table history data based on retention period                            | 2018-09-10 19:34:59.000 |                    0 |                    0 |                   0 |         1 | c5abdd98-ff03-4872-b6ae-3775161fd2da | Executed as user: NT SERVICE\SQLAgent$SQL2017. The step succeeded. | Enabled         | [Uncategorized (Local)] |
| sysutility_get_cache_tables_data_into_aggregate_tables_daily |      3 | Purge resource health policy evaluation history based on trailing window            | 2018-09-10 19:34:59.000 |                    0 |                    0 |                   0 |         1 | c5abdd98-ff03-4872-b6ae-3775161fd2da | Executed as user: NT SERVICE\SQLAgent$SQL2017. The step succeeded. | Enabled         | [Uncategorized (Local)] |
| sysutility_get_cache_tables_data_into_aggregate_tables_daily |      1 | Aggregate current days data from the cache tables into the server aggregation table | 2018-09-09 00:01:00.000 |                    0 |                    0 |                   0 |         1 | c5abdd98-ff03-4872-b6ae-3775161fd2da | Executed as user: NT SERVICE\SQLAgent$SQL2017. The step succeeded. | Enabled         | [Uncategorized (Local)] |
| sysutility_get_cache_tables_data_into_aggregate_tables_daily |      2 | Purge cache table history data based on retention period                            | 2018-09-09 00:01:00.000 |                    0 |                    0 |                   0 |         1 | c5abdd98-ff03-4872-b6ae-3775161fd2da | Executed as user: NT SERVICE\SQLAgent$SQL2017. The step succeeded. | Enabled         | [Uncategorized (Local)] |
| sysutility_get_cache_tables_data_into_aggregate_tables_daily |      3 | Purge resource health policy evaluation history based on trailing window            | 2018-09-09 00:01:00.000 |                    0 |                    0 |                   0 |         1 | c5abdd98-ff03-4872-b6ae-3775161fd2da | Executed as user: NT SERVICE\SQLAgent$SQL2017. The step succeeded. | Enabled         | [Uncategorized (Local)] |
| sysutility_get_cache_tables_data_into_aggregate_tables_daily |      1 | Aggregate current days data from the cache tables into the server aggregation table | 2018-09-08 12:23:17.000 |                    0 |                    0 |                   0 |         1 | c5abdd98-ff03-4872-b6ae-3775161fd2da | Executed as user: NT SERVICE\SQLAgent$SQL2017. The step succeeded. | Enabled         | [Uncategorized (Local)] |
| sysutility_get_cache_tables_data_into_aggregate_tables_daily |      2 | Purge cache table history data based on retention period                            | 2018-09-08 12:23:17.000 |                    0 |                    0 |                   0 |         1 | c5abdd98-ff03-4872-b6ae-3775161fd2da | Executed as user: NT SERVICE\SQLAgent$SQL2017. The step succeeded. | Enabled         | [Uncategorized (Local)] |
| sysutility_get_cache_tables_data_into_aggregate_tables_daily |      3 | Purge resource health policy evaluation history based on trailing window            | 2018-09-08 12:23:17.000 |                    0 |                    0 |                   0 |         1 | c5abdd98-ff03-4872-b6ae-3775161fd2da | Executed as user: NT SERVICE\SQLAgent$SQL2017. The step succeeded. | Enabled         | [Uncategorized (Local)] |
| sysutility_get_cache_tables_data_into_aggregate_tables_daily |      1 | Aggregate current days data from the cache tables into the server aggregation table | 2018-09-07 00:01:00.000 |                    0 |                    0 |                   0 |         1 | c5abdd98-ff03-4872-b6ae-3775161fd2da | Executed as user: NT SERVICE\SQLAgent$SQL2017. The step succeeded. | Enabled         | [Uncategorized (Local)] |
| sysutility_get_cache_tables_data_into_aggregate_tables_daily |      2 | Purge cache table history data based on retention period                            | 2018-09-07 00:01:00.000 |                    0 |                    0 |                   0 |         1 | c5abdd98-ff03-4872-b6ae-3775161fd2da | Executed as user: NT SERVICE\SQLAgent$SQL2017. The step succeeded. | Enabled         | [Uncategorized (Local)] |


Table: Job List
| JobName                                       |
|:----------------------------------------------|
| BlitzFirst                                    |
| MaintenancePlan.Subplan_1                     |
| OtherMaintenancePlan.Subplan_1                |
| ThirdMaintenancePlan.Subplan_1                |
| ThirdMaintenancePlan.Subplan_2                |
| collection_set_1_noncached_collect_and_upload |
| collection_set_2_collection                   |
| collection_set_2_upload                       |
| collection_set_3_collection                   |
| collection_set_3_upload                       |


Table: Job Overview
| name                                          | is_enabled               | owner_name     | shortest_duration   | longest_duration   | last_run_date       | next_run_date       | frequency         | schedule      | schedule_detail                                         |   job_success |   job_cancel |   job_retry |   job_fail | last_failure_date   | operator_id_emailed   | log_when           | email_when   | operator_name   | operator_email_address   | is_operator_enabled   | schedule_name                                 | schedule_enabled   |
|:----------------------------------------------|:-------------------------|:---------------|:--------------------|:-------------------|:--------------------|:--------------------|:------------------|:--------------|:--------------------------------------------------------|--------------:|-------------:|------------:|-----------:|:--------------------|:----------------------|:-------------------|:-------------|:----------------|:-------------------------|:----------------------|:----------------------------------------------|:-------------------|
| collection_set_2_upload                       | Disabled -- Should I be? | sa             | 00:00:00:00         | 00:00:00:18        | Feb 19 2018  3:12AM | Feb 19 2018  3:15AM | Daily             | Every 1 day(s | Occurs every 15 Minute(s) between 00:00:00 and 23:59:59 |             5 |            0 |           0 |          0 | N/A                 | 0                     | When the job fails | Never        | No operator     | No email address         | Not Enabled           | CollectorSchedule_Every_15min                 | Yes                |
| collection_set_1_noncached_collect_and_upload | Disabled -- Should I be? | sa             | 00:00:00:00         | 00:00:00:07        | Feb 19 2018  2:33AM | Feb 19 2018  6:00AM | Daily             | Every 1 day(s | Occurs every 6 Hour(s) between 00:00:00 and 23:59:59    |             2 |            0 |           0 |          0 | N/A                 | 0                     | When the job fails | Never        | No operator     | No email address         | Not Enabled           | CollectorSchedule_Every_6h                    | Yes                |
| collection_set_3_upload                       | Disabled -- Should I be? | sa             | 00:00:00:00         | 00:00:00:03        | Feb 19 2018  2:49AM | Feb 19 2018  3:00AM | Daily             | Every 1 day(s | Occurs every 15 Minute(s) between 00:00:00 and 23:59:59 |             3 |            0 |           0 |          0 | N/A                 | 0                     | When the job fails | Never        | No operator     | No email address         | Not Enabled           | CollectorSchedule_Every_15min                 | Yes                |
| collection_set_2_collection                   | Disabled -- Should I be? | sa             | 00:00:16:35         | 00:00:22:48        | Feb 19 2018  3:12AM | N/A                 | When Agent starts | N/A           | N/A                                                     |             0 |            2 |           0 |          0 | N/A                 | 0                     | When the job fails | Never        | No operator     | No email address         | Not Enabled           | RunAsSQLAgentServiceStartSchedule             | Yes                |
| collection_set_3_collection                   | Disabled -- Should I be? | sa             | 00:00:16:37         | 00:00:16:37        | Feb 19 2018  2:49AM | N/A                 | When Agent starts | N/A           | N/A                                                     |             0 |            1 |           0 |          0 | N/A                 | 0                     | When the job fails | Never        | No operator     | No email address         | Not Enabled           | RunAsSQLAgentServiceStartSchedule             | Yes                |
| BlitzFirst                                    | Enabled                  | THEBEAST\Menny | 00:00:00:05         | 00:00:00:08        | Sep 10 2018 11:40PM | Sep 10 2018 11:45PM | Daily             | Every 1 day(s | Occurs every 5 Minute(s) between 00:00:00 and 23:59:59  |            50 |            0 |           0 |          0 | N/A                 | 0                     | Never              | Never        | No operator     | No email address         | Not Enabled           | 5 minutes                                     | Yes                |
| ThirdMaintenancePlan.Subplan_1                | Enabled                  | THEBEAST\Menny | 00:00:00:02         | 00:00:00:29        | Sep 10 2018 11:40PM | Sep 10 2018 11:50PM | Daily             | Every 1 day(s | Occurs every 10 Minute(s) between 00:00:00 and 23:59:59 |            50 |            0 |           0 |          0 | N/A                 | 0                     | When the job fails | Never        | No operator     | No email address         | Not Enabled           | ThirdMaintenancePlan.Check Database Integrity | Yes                |
| ThirdMaintenancePlan.Subplan_2                | Enabled                  | THEBEAST\Menny | 00:00:00:00         | 00:27:35:52        | Sep 10 2018 11:41PM | Sep 10 2018 11:48PM | Daily             | Every 1 day(s | Occurs every 7 Minute(s) between 00:00:00 and 23:59:59  |            50 |            0 |           0 |          0 | N/A                 | 0                     | When the job fails | Never        | No operator     | No email address         | Not Enabled           | ThirdMaintenancePlan.Rebuild Index            | Yes                |
| MaintenancePlan.Subplan_1                     | Enabled                  | THEBEAST\Menny | 00:00:02:11         | 00:00:03:44        | Sep 10 2018  7:37PM | Sep 11 2018 12:00AM | Daily             | Every 1 day(s | Occurs every 15 Minute(s) between 00:00:00 and 23:59:59 |             0 |            0 |           0 |          9 | Sep  5 2018 12:00AM | No operator emailed   | When the job fails | Never        | No operator     | No email address         | Not Enabled           | OccursEvery15Minutes                          | No                 |
| MaintenancePlan.Subplan_1                     | Enabled                  | THEBEAST\Menny | 00:00:02:11         | 00:00:03:44        | Sep 10 2018  7:37PM | Sep 11 2018 12:00AM | Daily             | Every 1 day(s | Occurs once at 00:00:00                                 |             0 |            0 |           0 |          9 | Sep  5 2018 12:00AM | No operator emailed   | When the job fails | Never        | No operator     | No email address         | Not Enabled           | MaintenancePlan                               | Yes                |


Table: Job Schedule
|   schedule_id | job_id                               | JobName                                                       | ScheduleName                     | Next_RunDateTime        |
|--------------:|:-------------------------------------|:--------------------------------------------------------------|:---------------------------------|:------------------------|
|             4 | 857b2530-3c4c-49c6-9f58-090ebb3f76c8 | collection_set_2_upload                                       | CollectorSchedule_Every_15min    | 2018-09-02 13:00:00.000 |
|            12 | 16493ac7-1aa4-4a39-975b-0a82def040fe | sysutility_get_cache_tables_data_into_aggregate_tables_hourly | OccursEveryOneHour               | 2018-09-10 22:01:00.000 |
|            10 | 9096dc29-e15a-4002-a262-3381b131cd46 | mdw_purge_data_[TEST]                                         | mdw_purge_data_schedule          | 2018-09-11 02:00:00.000 |
|            13 | c5abdd98-ff03-4872-b6ae-3775161fd2da | sysutility_get_cache_tables_data_into_aggregate_tables_daily  | OccursOnceADayAt12:01AM          | 2018-09-11 00:01:00.000 |
|             8 | 8f595149-adf1-4b6f-96ce-5749e0f1845f | syspolicy_purge_history                                       | syspolicy_purge_history_schedule | 2018-09-11 02:00:00.000 |
|             7 | 2aef96e4-5508-479f-8306-58451245a7ee | collection_set_1_noncached_collect_and_upload                 | CollectorSchedule_Every_6h       | 2018-09-02 18:00:00.000 |
|             4 | 96e6c092-6622-48e1-bb49-688d53427309 | collection_set_3_upload                                       | CollectorSchedule_Every_15min    | 2018-09-02 13:00:00.000 |
|            11 | 1b074609-f793-4ef7-a3b8-6d51a87d6f7a | MaintenancePlan.Subplan_1                                     | OccursEvery15Minutes             |                         |
|            15 | 1b074609-f793-4ef7-a3b8-6d51a87d6f7a | MaintenancePlan.Subplan_1                                     | MaintenancePlan                  | 2018-09-11 00:00:00.000 |
|            16 | 33082f57-2a3c-48bb-aa79-832a801455c5 | OtherMaintenancePlan.Subplan_1                                | OtherMaintenancePlan.Subplan_1   | 2018-09-10 21:50:00.000 |


Table: Job Top n By Duration
|   ID | Job ID                               | Job Name                                                      | Owner Name     |   Schedules Count |   Steps Count |   Failure Count |   Average Run Duration |   Average  Retries Attempted |   Execution Count |   l1 |
|-----:|:-------------------------------------|:--------------------------------------------------------------|:---------------|------------------:|--------------:|----------------:|-----------------------:|-----------------------------:|------------------:|-----:|
|    1 | 33082f57-2a3c-48bb-aa79-832a801455c5 | OtherMaintenancePlan.Subplan_1                                | THEBEAST\Menny |                 1 |             1 |               0 |           15381.6      |                            0 |                27 |    1 |
|    2 | 1d4c8323-2475-4769-bc68-bd8179070b47 | ThirdMaintenancePlan.Subplan_2                                | THEBEAST\Menny |                 1 |             1 |               0 |            1991.26     |                            0 |                50 |    1 |
|    3 | 1b074609-f793-4ef7-a3b8-6d51a87d6f7a | MaintenancePlan.Subplan_1                                     | THEBEAST\Menny |                 2 |             1 |               8 |             171.75     |                            0 |                 8 |    1 |
|    4 | 8f595149-adf1-4b6f-96ce-5749e0f1845f | syspolicy_purge_history                                       | sa             |                 1 |             3 |               0 |              11        |                            0 |                 3 |    1 |
|    5 | 0d916804-4479-4c3d-8f7a-ff6239e40a88 | ThirdMaintenancePlan.Subplan_1                                | THEBEAST\Menny |                 1 |             1 |               0 |               8.9      |                            0 |                50 |    1 |
|    6 | 6b282c85-6608-4cc0-bcc9-fe8f50ff3f0d | BlitzFirst                                                    | THEBEAST\Menny |                 1 |             1 |               0 |               6.1      |                            0 |                50 |    1 |
|    7 | 35831f9a-0a75-496d-bfa1-94ed130a78bb | sysutility_get_views_data_into_cache_tables                   | sa             |                 1 |             3 |               0 |               4.08     |                            0 |                25 |    1 |
|    8 | 9096dc29-e15a-4002-a262-3381b131cd46 | mdw_purge_data_[TEST]                                         | THEBEAST\Menny |                 1 |             1 |               0 |               2.66667  |                            0 |                 3 |    1 |
|    9 | c5abdd98-ff03-4872-b6ae-3775161fd2da | sysutility_get_cache_tables_data_into_aggregate_tables_daily  | sa             |                 1 |             3 |               0 |               1.42857  |                            0 |                 7 |    1 |
|   10 | 16493ac7-1aa4-4a39-975b-0a82def040fe | sysutility_get_cache_tables_data_into_aggregate_tables_hourly | sa             |                 1 |             1 |               0 |               0.137931 |                            0 |                29 |    1 |


Table: Job Top n By Failures
|   ID | Job ID                               | Job Name                  | Owner Name     |   run_status |   Schedules Count |   Steps Count |   Execution Count |   Average Run Duration |   Average  Retries Attempted |   Failure Count |   l1 |
|-----:|:-------------------------------------|:--------------------------|:---------------|-------------:|------------------:|--------------:|------------------:|-----------------------:|-----------------------------:|----------------:|-----:|
|    1 | 1b074609-f793-4ef7-a3b8-6d51a87d6f7a | MaintenancePlan.Subplan_1 | THEBEAST\Menny |            0 |                 2 |             1 |                 8 |                 171.75 |                            0 |               8 |    1 |


Table: Job Top n By Frequency
|   ID | Job ID                               | Job Name                                                      | Owner Name     |   Schedules Count |   Steps Count |   Failure Count |   Average Run Duration |   Average  Retries Attempted |   Execution Count |   l1 |
|-----:|:-------------------------------------|:--------------------------------------------------------------|:---------------|------------------:|--------------:|----------------:|-----------------------:|-----------------------------:|------------------:|-----:|
|    1 | 1d4c8323-2475-4769-bc68-bd8179070b47 | ThirdMaintenancePlan.Subplan_2                                | THEBEAST\Menny |                 1 |             1 |               0 |            1991.26     |                            0 |                50 |    1 |
|    2 | 6b282c85-6608-4cc0-bcc9-fe8f50ff3f0d | BlitzFirst                                                    | THEBEAST\Menny |                 1 |             1 |               0 |               6.1      |                            0 |                50 |    1 |
|    3 | 0d916804-4479-4c3d-8f7a-ff6239e40a88 | ThirdMaintenancePlan.Subplan_1                                | THEBEAST\Menny |                 1 |             1 |               0 |               8.9      |                            0 |                50 |    1 |
|    4 | 16493ac7-1aa4-4a39-975b-0a82def040fe | sysutility_get_cache_tables_data_into_aggregate_tables_hourly | sa             |                 1 |             1 |               0 |               0.137931 |                            0 |                29 |    1 |
|    5 | 33082f57-2a3c-48bb-aa79-832a801455c5 | OtherMaintenancePlan.Subplan_1                                | THEBEAST\Menny |                 1 |             1 |               0 |           15381.6      |                            0 |                27 |    1 |
|    6 | 35831f9a-0a75-496d-bfa1-94ed130a78bb | sysutility_get_views_data_into_cache_tables                   | sa             |                 1 |             3 |               0 |               4.08     |                            0 |                25 |    1 |
|    7 | 1b074609-f793-4ef7-a3b8-6d51a87d6f7a | MaintenancePlan.Subplan_1                                     | THEBEAST\Menny |                 2 |             1 |               8 |             171.75     |                            0 |                 8 |    1 |
|    8 | c5abdd98-ff03-4872-b6ae-3775161fd2da | sysutility_get_cache_tables_data_into_aggregate_tables_daily  | sa             |                 1 |             3 |               0 |               1.42857  |                            0 |                 7 |    1 |
|    9 | 8f595149-adf1-4b6f-96ce-5749e0f1845f | syspolicy_purge_history                                       | sa             |                 1 |             3 |               0 |              11        |                            0 |                 3 |    1 |
|   10 | 9096dc29-e15a-4002-a262-3381b131cd46 | mdw_purge_data_[TEST]                                         | THEBEAST\Menny |                 1 |             1 |               0 |               2.66667  |                            0 |                 3 |    1 |


Table: Maintenance Plans Tasks
| PlanName        | SubPlan   | Task                     | DatabaseName   | JobName                   |
|:----------------|:----------|:-------------------------|:---------------|:--------------------------|
| MaintenancePlan | Subplan_1 | Check Database Integrity | master         | MaintenancePlan_Subplan_1 |
| MaintenancePlan | Subplan_1 | Maintenance Cleanup Task | master         | MaintenancePlan_Subplan_1 |
| MaintenancePlan | Subplan_1 | Update Statistics        | master         | MaintenancePlan_Subplan_1 |
| MaintenancePlan | Subplan_1 | Check Database Integrity | model          | MaintenancePlan_Subplan_1 |
| MaintenancePlan | Subplan_1 | Maintenance Cleanup Task | model          | MaintenancePlan_Subplan_1 |
| MaintenancePlan | Subplan_1 | Update Statistics        | model          | MaintenancePlan_Subplan_1 |
| MaintenancePlan | Subplan_1 | Check Database Integrity | msdb           | MaintenancePlan_Subplan_1 |
| MaintenancePlan | Subplan_1 | Maintenance Cleanup Task | msdb           | MaintenancePlan_Subplan_1 |
| MaintenancePlan | Subplan_1 | Update Statistics        | msdb           | MaintenancePlan_Subplan_1 |
| MaintenancePlan | Subplan_1 | Check Database Integrity | DBMaintenance  | MaintenancePlan_Subplan_1 |


Table: Maintenance Plans
| name                 | id                                   | owner          |   Subplan_Count |   avg_runtime_seconds |   failures | maintenance_plan_steps                                                           |
|:---------------------|:-------------------------------------|:---------------|----------------:|----------------------:|-----------:|:---------------------------------------------------------------------------------|
| MaintenancePlan      | 96e00c8f-2dc3-4bd2-85e7-896598667393 | THEBEAST\Menny |               1 |                   163 |          9 | Subplan_1, Check Database Integrity, Maintenance Cleanup Task, Update Statistics |
| OtherMaintenancePlan | 5938aeb2-1a7f-4e65-addb-2ea69d2efb4b | THEBEAST\Menny |               1 |                 15379 |          1 | Subplan_1, Update Statistics                                                     |
| ThirdMaintenancePlan | 719c9ad6-2488-44c9-b367-b28f71665798 | THEBEAST\Menny |               2 |                   244 |          0 | Subplan_1, Check Database Integrity, Subplan_2, Rebuild Index                    |


Table: Schedules
|   ScheduleID | ScheduleName                  | IsEnabled   | ScheduleType   | Occurrence   | Recurrence            | Frequency                                             | ScheduleUsageStartDate   | ScheduleUsageEndDate   | ScheduleCreatedOn       | ScheduleLastModifiedOn   |
|-------------:|:------------------------------|:------------|:---------------|:-------------|:----------------------|:------------------------------------------------------|:-------------------------|:-----------------------|:------------------------|:-------------------------|
|            9 | 5 minutes                     | Yes         | Recurring      | Daily        | Occurs every 1 day(s) | Occurs every 5 Minute(s) between 00:00:00 & 23:59:59  | 2018-02-18               | 9999-12-31             | 2018-02-18 00:15:26.396 | 2018-02-18 00:15:26.396  |
|            3 | CollectorSchedule_Every_10min | Yes         | Recurring      | Daily        | Occurs every 1 day(s) | Occurs every 10 Minute(s) between 00:00:00 & 23:59:59 | 2017-08-22               | 9999-12-31             | 2017-08-22 19:39:29.150 | 2017-08-22 19:39:29.150  |
|            4 | CollectorSchedule_Every_15min | Yes         | Recurring      | Daily        | Occurs every 1 day(s) | Occurs every 15 Minute(s) between 00:00:00 & 23:59:59 | 2017-08-22               | 9999-12-31             | 2017-08-22 19:39:29.150 | 2017-08-22 19:39:29.150  |
|            5 | CollectorSchedule_Every_30min | Yes         | Recurring      | Daily        | Occurs every 1 day(s) | Occurs every 30 Minute(s) between 00:00:00 & 23:59:59 | 2017-08-22               | 9999-12-31             | 2017-08-22 19:39:29.150 | 2017-08-22 19:39:29.150  |
|            2 | CollectorSchedule_Every_5min  | Yes         | Recurring      | Daily        | Occurs every 1 day(s) | Occurs every 5 Minute(s) between 00:00:00 & 23:59:59  | 2017-08-22               | 9999-12-31             | 2017-08-22 19:39:29.150 | 2017-08-22 19:39:29.150  |
|            6 | CollectorSchedule_Every_60min | Yes         | Recurring      | Daily        | Occurs every 1 day(s) | Occurs every 60 Minute(s) between 00:00:00 & 23:59:59 | 2017-08-22               | 9999-12-31             | 2017-08-22 19:39:29.150 | 2017-08-22 19:39:29.150  |
|            7 | CollectorSchedule_Every_6h    | Yes         | Recurring      | Daily        | Occurs every 1 day(s) | Occurs every 6 Hour(s) between 00:00:00 & 23:59:59    | 2017-08-22               | 9999-12-31             | 2017-08-22 19:39:29.150 | 2017-08-22 19:39:29.150  |
|           15 | MaintenancePlan               | Yes         | Recurring      | Daily        | Occurs every 1 day(s) | Occurs once at 00:00:00                               | 2018-09-02               | 9999-12-31             | 2018-09-02 12:49:57.666 | 2018-09-02 12:49:57.666  |
|           10 | mdw_purge_data_schedule       | Yes         | Recurring      | Daily        | Occurs every 1 day(s) | Occurs once at 02:00:00                               | 2018-02-19               | 9999-12-31             | 2018-02-19 02:32:43.180 | 2018-02-19 02:32:43.180  |
|           11 | OccursEvery15Minutes          | No          | Recurring      | Daily        | Occurs every 1 day(s) | Occurs every 15 Minute(s) between 00:00:00 & 23:59:59 | 2018-02-19               | 9999-12-31             | 2018-02-19 02:32:43.506 | 2018-09-08 16:25:23.356  |

 


tables: name: Job History
data: Job History.csv
name: Job List
data: Job List.csv
name: Job Overview
data: Job Overview.csv
name: Job Schedule
data: Job Schedule.csv
name: Job Top n By Duration
data: Job Top n By Duration.csv
name: Job Top n By Failures
data: Job Top n By Failures.csv
name: Job Top n By Frequency
data: Job Top n By Frequency.csv
name: Maintenance Plans Tasks
data: Maintenance Plans Tasks.csv
name: Maintenance Plans
data: Maintenance Plans.csv
name: Schedules
data: Schedules.csv
label: Maintenance Plans Tasks
PlanName
Maintenance Plans
name
Job Schedule
schedule_id
Schedules
ScheduleID
Job History
JobName
Job List
JobName
Job Overview
name
Job List
JobName
Maintenance Plans Tasks
JobName
Job List
JobName
Job Schedule
JobName
Job List
JobName
Job Top n By Duration
Job Name
Job List
JobName
Job Top n By Frequency
Job Name
Job List
JobName
Job Top n By Failures
Job Name
Job List
JobName
output: {
    "joins": [
        {
            "from_table": "Maintenance Plans Tasks",
            "from_column": "PlanName",
            "to_table": "Maintenance Plans",
            "to_column": "name"
        },
        {
            "from_table": "Job Schedule",
            "from_column": "schedule_id",
            "to_table": "Schedules",
            "to_column": "ScheduleID"
        },
        {
            "from_table": "Job History",
            "from_column": "JobName",
            "to_table": "Job List",
            "to_column": "JobName"
        },
        {
            "from_table": "Job Overview",
            "from_column": "name",
            "to_table": "Job List",
            "to_column": "JobName"
        },
        {
            "from_table": "Maintenance Plans Tasks",
            "from_column": "JobName",
            "to_table": "Job List",
            "to_column": "JobName"
        },
        {
            "from_table": "Job Schedule",
            "from_column": "JobName",
            "to_table": "Job List",
            "to_column": "JobName"
        },
        {
            "from_table": "Job Top n By Duration",
            "from_column": "Job Name",
            "to_table": "Job List",
            "to_column": "JobName"
        },
        {
            "from_table": "Job Top n By Frequency",
            "from_column": "Job Name",
            "to_table": "Job List",
            "to_column": "JobName"
        },
        {
            "from_table": "Job Top n By Failures",
            "from_column": "Job Name",
            "to_table": "Job List",
            "to_column": "JobName"
        }
    ]
}