---
parser: v2
author_name: Dan van Leeuwen
author_profile: https://github.com/danielva
auto_validation: true
time: 30
tags: [ tutorial>beginner, software-product-function>sap-hana-cloud--sap-hana-database, software-product>sap-hana-cloud, software-product>sap-alert-notification-service-for-sap-btp, software-product>sap-automation-pilot, programming-tool>python]
primary_tag: software-product>sap-hana-cloud
slug: hana-cloud-alerts-custom
canonical_url: https://developers.sap.com/tutorials/hana-cloud-alerts-custom
---

# Execute SQL Commands and Create Custom Notifications with SAP Automation Pilot and SAP Alert Notification Service
<!-- description --> Learn an approach to schedule SQL statements which are run against an SAP HANA Cloud database and send an email based on the results of the execution.

## Prerequisites
  - Access to the SAP Business Technology Platform (BTP) that includes SAP HANA Cloud, SAP Alert Notification Service, and SAP Automation Pilot.  These services are available in the SAP BTP free tier.

## You will learn
  - How to create a command in SAP Automation Pilot which connects to and queries an SAP HANA Cloud database instance
  - How to perform queries using the provided `ExecuteHanaCloudSqlStatement`
  - How to perform queries using `hdbcli`, the SAP HANA client driver for Python
  - How to conditionally send a notification (email) with the results of the query using the SAP Alert Notification Service
  - How to schedule an SAP Automation Pilot command

## Intro
SAP HANA Cloud provides built-in alerts for items such as long running statements, table row counts, expiring database passwords, or low disk space.  This tutorial will demonstrate an approach that can be used to create a notification for use cases not covered by the built-in alerts.  The hotels dataset described in the tutorial [Create Database Objects with SAP HANA Database Explorer](hana-dbx-create-schema) contains a maintenance table where work items are described.  

![maintenance table](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/hana-cloud-alerts-custom/maintenance-table.png)

An SAP Automation Pilot command will be created to check if any maintenance items are unassigned, and if so, an email will be generated.  The final step in the tutorial will demonstrate how to schedule the command to run once a week.

![scenario](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/hana-cloud-alerts-custom/scenario.png)

>If you do not already have the `HOTELS.MAINTENANCE` table in an SAP HANA Cloud database, please create it now by following the first 2 steps in the [Create Database Objects with SAP HANA Database Explorer](hana-dbx-create-schema) tutorial.
>
>If you do not have a subscription to the SAP Automation Pilot service, step 1 of the tutorial [Take Action Following a SAP HANA Cloud Database Alert with SAP Automation Pilot](hana-cloud-alerts-autopilot) provides details on how to so.  
>
>If you do not have an instance of the SAP Alert Notification service, see step 5 of the tutorial [Alerts in SAP HANA Database and Data Lake](hana-cloud-alerts).

---

### Create an SAP Automation Pilot command
This step will create a catalog, an input, and a command in the SAP Automation Pilot.  The command in subsequent steps will execute SQL against the database to determine if there are any unassigned maintenance items.  

1. In the SAP Automation Pilot, create a new catalog.

    ![create a catalog](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/hana-cloud-alerts-custom/create-catalog.png)

    Specify the values below.

    | Label | Value |
    | -------- | ----- |
    | Name | `CustNotif` |
    | Display name | `Custom Notifications` |
    | Description | `A user catalog which will hold inputs and commands demonstrating how to perform a custom notification` |

2. Create an input to store the connection details for an SAP HANA Cloud database.  

    ![create input](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/hana-cloud-alerts-custom/create-input-hc.png)

    Specify the values below.

    | Label | Value |
    | -------- | ----- |
    | Catalog | `Custom Notifications` |
    | Name | `SAPHANADB` |
    | Description | `Contains the details to connect to a specific SAP HANA Cloud database` |

3. Add the following keys to the input.

    ![input with keys](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/hana-cloud-alerts-custom/input-hc.png)

    | Key Name | Type | Sensitive | Description | Value |
    | -------- | ----- | --- | --- | --- |
    | host | String | no | Host value for a SAP HANA Cloud database | *Copy the SQL Endpoint from SAP HANA Cloud Central and remove :443* |
    | port | Number | no | Port value for a SAP HANA Cloud database | `443` |
    | user | String | no | The user ID to connect the database | `USER1` |
    | password | String | yes | The password to connect the database | `Password1` |

    >Storing values in an input enables the values to be reused across different commands. If a value needs to be updated, it only has to be updated in one place.

4. Create a command.

    ![create command](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/hana-cloud-alerts-custom/create-command.png)

    Specify the values below.

    | Label | Value |
    | -------- | ----- |
    | Catalog | `Custom Notifications` |
    | Name | `CheckMaintenanceItems` |
    | Description | `Perform a check to see if there are any unassigned maintenance items` |

5. In the newly created command, select input and add an [additional value](https://help.sap.com/docs/AUTOMATION_PILOT/de3900c419f5492a8802274c17e07049/f70c599222084a13a13cbd69263d3f44.html) which is the `SAPHANADB` input.

    ![add additional values](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/hana-cloud-alerts-custom/additional-value.png)

    Specify the values below.

    | Label | Value |
    | -------- | ----- |
    | Alias | `scriptInput` |
    | Value Type | `Input` |
    | Input | `SAPHANADB` |

    >An alternative method of passing parameters to the command uses the input keys in the contract section.  This is shown in step 4.

6. Add an output key.

    ![output key](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/hana-cloud-alerts-custom/output-key.png)

    Specify the values below.

    | Label | Value |
    | -------- | ----- |
    | Name | `checkResult` |
    | Type | `string` |
    | Sensitive | `No` |    
    | Description | `JSON string of the result` |

7. Under Configuration, add an executor.  

    ![Add executor](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/hana-cloud-alerts-custom/add-executor.png)

    Click on **Here** and specify the values below.

    ![Add an executor](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/hana-cloud-alerts-custom/query-db.png)

    | Label | Value |
    | -------- | ----- |
    | Alias | `QueryDB` |
    | Command | `ExecuteScript (Version: 2)` |
    | Automap Parameters | `true` |

    > :2 indicates that this is version 2 of the command.

    > `Automap parameters` is not used in this tutorial, so its value can be enabled or disabled.

8. Select `QueryDB` and then press the edit parameters button.

    ![parameters](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/hana-cloud-alerts-custom/query-db-parameters.png)

    Paste in the following code for the script parameter.  

   ```Python
   #!/usr/bin/env python3

   print("Hello from QueryDB!")
   ```

9. Select the output and choose Edit.

    ![edit output](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/hana-cloud-alerts-custom/edit-output.png)

    | Label | Value |
    | -------- | ----- |
    | checkResult | `$(.QueryDB.output.output[0])` |
    
    This will take the result printed in the `QueryDB` executor and set it to the output of the command.

    > For additional details on the use of the `$(...)` used above, see [Dynamic Expression](https://help.sap.com/viewer/de3900c419f5492a8802274c17e07049/Cloud/en-US/22621f87e7574f9e9fd1b1b95fe7a61d.html).

10. Trigger the execution.

    ![trigger the command](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/hana-cloud-alerts-custom/manual-trigger-command.png)

    Additional inputs are not needed.

    ![trigger command dialog](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/hana-cloud-alerts-custom/trigger-hello.png)

    After a few seconds, the output can be seen.

    ![execution output](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/hana-cloud-alerts-custom/execution-output.png)

    ![Output value](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/hana-cloud-alerts-custom/manual-trigger-command-hello.png)

    >A quick way to return to the command after executing it is to click on the link shown below.

    >![Return to command](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/hana-cloud-alerts-custom/return-to-command.png)

At this point, a command has been created and executed.  In the next two steps, two different techniques of executing SQL against an SAP HANA Cloud database will be shown.  


### Perform a query using the ExecuteHanaCloudSqlStatement command
This step will add an additional executor to the command that can connect to a SAP HANA Cloud database and execute a query.

1. Under Configuration, add an executor.  

    ![Add executor](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/hana-cloud-alerts-custom/add-executor-sql.png)

    Click on Here and specify the values below.

    ![Add an executor](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/hana-cloud-alerts-custom/query-db-sql.png)

    | Label | Value |
    | -------- | ----- |
    | Alias | `SQLStatement` |
    | Command | `ExecuteHanaCloudSqlStatement` |
    | Automap Parameters | `true` |

2. Select `SQLStatement` and then press the edit parameters button.

    ![parameters](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/hana-cloud-alerts-custom/sql-statement-edit.png)

    Set the Connection URL to be `jdbc:sap://$(.scriptInput.host):$(.scriptInput.port)`.

3.  Under Statement, specify the SQL below.

   ```SQL
   SELECT H.NAME, M.DESCRIPTION FROM HOTELS.MAINTENANCE M, HOTELS.HOTEL H WHERE M.HNO = H.HNO;
   ```

   ![statement](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/hana-cloud-alerts-custom/statement.png)

4. Under Authentication specify the values below.

    ![authentication](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/hana-cloud-alerts-custom/authentication.png)

    | Key | Value |
    | -------- | ----- |
    | Type | `Basic Authentication` |
    | User | `$(.scriptInput.user)` |
    | Password | `$(.scriptInput.password)` |

    Notice that the user or password inputs provide autocompletion after `$(.` is entered.

    ![auto complete](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/hana-cloud-alerts-custom/auto-complete.png)

5. Under Advanced specify the values below.

    ![advanced](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/hana-cloud-alerts-custom/advanced.png)

    | Key | Value |
    | -------- | ----- |
    | Result Row Format: | `Object` |
    | Result Transformer | `toArray[0]` |


6. Select `QueryDB`. Then press the edit parameters button.

    ![edit QueryDB](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/hana-cloud-alerts-custom/edit-querydb.png)

    Paste in the following code for the script parameter replacing the previous content.  

    ![script](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/hana-cloud-alerts-custom/script.png)

   ```Python
   #!/usr/bin/env python3

   import sys, json

   input = sys.stdin.readline()
   rows = json.loads(input)
   print(rows)
   ```

    Under STDIN, specify `$(.SQLStatement.output.result)` so that the output of the previous step can be accessed in the Python code.

    ![STDIN](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/hana-cloud-alerts-custom/stdin1.png)


7. Trigger the execution.  Additional inputs are not needed.

    ![trigger the command](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/hana-cloud-alerts-custom/manual-trigger-command.png)

    The output can be seen below.

    ![Output value](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/hana-cloud-alerts-custom/manual-trigger-command-sql.png)

The above step demonstrates how the provided [SQL Statement](https://help.sap.com/docs/AUTOMATION_PILOT/de3900c419f5492a8802274c17e07049/024ff1ff1c46465f838c6faf655a9f0a.html) command can be used. Its output was passed into a Python command, where the result could be further processed. The next step is an example to execute SQL statements directly in the Python command.   


### Perform a query using hdbcli in a Python script
This step will demonstrate how SQL queries can be made directly in Python rather than using a separate executor.

1. Optionally delete the executor `SQLStatement`.

2. Select `QueryDB` and then press the edit parameters button.

    ![parameters](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/hana-cloud-alerts-custom/query-db-parameters.png)

    Paste in the following code for the script parameter replacing the previous content.  

   ```Python
   #!/usr/bin/env python3

   import sys, os
   from hdbcli import dbapi

   #Note:  We cannot directly access input keys such as $(.execution.input.user) or additional parameter values $(.scriptInput.user) in a Python script
   host = os.environ.get("host")
   port = os.environ.get("port")
   user = os.environ.get("user")
   password = sys.stdin.readline()

   conn = dbapi.connect(
       address=host,
       port=port,
       user=user,
       password=password
   )

   cursor = conn.cursor()
   cursor.execute("SELECT count(*) AS UNASSIGNED_ITEMS FROM HOTELS.MAINTENANCE WHERE PERFORMED_BY IS NULL;")
   rows = cursor.fetchall()
   numOfUnassignedItems = 0
   severity = "INFO"

   for row in rows:
       numOfUnassignedItems = row[0]
       severity = "WARNING"
   
   cursor.close()
   print("There are " + str(numOfUnassignedItems) + " unassigned maintenance items.")
   print(severity)
   ```

    The provided executor [ExecuteScript](https://help.sap.com/docs/AUTOMATION_PILOT/de3900c419f5492a8802274c17e07049/d0854dbb80d84946bb57791db94b7e20.html) supports various languages and when Python is used, it includes the `hdbcli` which is the [Python driver for SAP HANA](hana-clients-python)  which is used to connect to and query an SAP HANA Cloud database.

3. In the next two sub-steps, connection details for the SAP HANA Cloud instance will be passed into the executor.  Under environment, specify the values below.

    | Key | Value |
    | -------- | ----- |
    | host | `$(.scriptInput.host)` |
    | port | `$(.scriptInput.port)` |
    | user | `$(.scriptInput.user)` |

    ![environment](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/hana-cloud-alerts-custom/environment.png)

    >Additional value keys or input keys cannot be directly referenced in a Python script and hence they need to be passed in through alternative means such as environment variables or `stdin`.  Step 3 makes use of input keys.

4. Under STDIN, replace the previous value with `$(.scriptInput.password)`

    ![standard in](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/hana-cloud-alerts-custom/stdin.png)

    >Passing the password through STDIN is more secure.

5. Trigger the execution.  Additional inputs are not needed.

    ![trigger the command](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/hana-cloud-alerts-custom/manual-trigger-command.png)

    The output can be seen below.

    ![Output value](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/hana-cloud-alerts-custom/manual-trigger-command-python.png)

    A command has now been successfully created that can execute SQL against an SAP HANA Cloud database using the Python SAP HANA Client.  With this method, the query and the logic to process the result can be done in one executor.


### Forward results to the SAP Alert Notification Service
A second executer will be added in this step.  It will take the output returned from `QueryDB` and forward it to the SAP Alert Notification Service which will then send the details via email. 


1. In the SAP Alert Notification Service, create a basic service key named `BasicANSServiceKey`.  The service key will provide the URL and credentials for the SAP Automation Pilot to send notifications to the SAP Alert Notification Service.

    ![Create an ANS service key](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/hana-cloud-alerts-custom/create-service-key.png)

   ```JSON
   {
	    "type": "BASIC"
   }
   ```
2. In the SAP Automation Pilot, create an input named 'ServiceKeyANS'.

    ![create input](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/hana-cloud-alerts-custom/service-key-ans.png)

    Specify the values below.

    | Label    | Value |
    | -------- | ----- |
    | Catalog  | `Custom Notifications` |
    | Name     | `ServiceKeyANS` |
    | Description | `Basic credentials (client_id and secret_key) used to access the SAP Automation Pilot` |

3. Add a key named `JSONKey` of type object marked as sensitive and paste in the JSON generated in step1.

    ![Add ANS Key](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/hana-cloud-alerts-custom/service-key-ans-2.png)

4. In the command, under Executors, select the input and choose Add.

    ![Add ANS Key](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/hana-cloud-alerts-custom/Add-Input-ANSKEY.png)

    Specify the values below.

    | Label | Value |
    | -------- | ----- |
    | Alias | `ANSKey` |
    | Value Type | `Input` |
    | Input | `ServiceKeyANS` |

5. Add a second executor.  

    ![add a second executor](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/hana-cloud-alerts-custom/add-2nd-executor.png)

     Place the executor between `QueryDB` and output.  This executor will send notifications to the SAP Automation Pilot.

    ![Add a notification executor](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/hana-cloud-alerts-custom/send-notification-executor.png)

    Specify the values below.

    | Label | Value |
    | ----- | ----- |
    | Alias | `SendNotification` |
    | Command | `SendAnsEvent` |
    | Automap Parameters | `true` |

6. Edit the parameters of the just added executor.

    ![edit parameters](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/hana-cloud-alerts-custom/edit-parameters.png)

    ![ANS event parameters](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/hana-cloud-alerts-custom/send-notification-parameters.png)

    Specify the values below.

    | Label | Value |
    | ----- | ----- |
    | body | `Reminder that there are $(.QueryDB.output.output[0]) unassigned maintenance items` |
    | category | `NOTIFICATION` |
    | eventType | `Unassigned_Maint_EVENT` |
    | resourceName | `unknown` |
    | resourceType | `unknown` |
    | serviceKey   | `$(.ANSKey.JSONKey)` |
    | severity   | `$(.QueryDB.output.output[1])` |
    | subject    | `$(.QueryDB.output.output[1]) Unassigned_Maint_EVENT` |

    The SAP Alert Notification Service is expecting the input data to be a JSON document.  Additional details can be found at [Producing Custom Events](https://help.sap.com/docs/AUTOMATION_PILOT/de3900c419f5492a8802274c17e07049/6124b87d6e0249be9ffbc5a091123f97.html) and [Cloud Foundry Producer API (Model View)](https://api.sap.com/api/cf_producer_api/schema).

7. Trigger the command.

    ![successful request](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/hana-cloud-alerts-custom/successful-request.png)

    The next step will create a subscription in the SAP Alert Notification Service that will be triggered by the just sent JSON and can then perform an action such as send an email.


### Send a notification when there are unassigned maintenance items
The following instructions use the SAP Alert Notification Service to send an email when there are unassigned maintenance items.

1. In the SAP Alert Notification Service, create a condition.

    ![create condition](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/hana-cloud-alerts-custom/create-condition.png)

    Specify the values below.

    | Label | Value |
    | ----- | ----- |
    | Name | `Unassigned-Maintenance-Items` |
    | Condition | `eventType` is Equal To `Unassigned_Maint_EVENT` |
    | Description | `There are items in the table HOTELS.MAINTENANCE that are not assigned.` |  

    ![create condition details](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/hana-cloud-alerts-custom/create-condition-details.png)

    >A further condition could be added to send an email only when the severity equals WARNING.  When the severity is INFO, there were no unassigned maintenance items.  
    >
    >An additional approach would be to apply a condition on `SendNotification` to indicate that it should only execute if the number of unassigned maintenance items does not equal to 0.

    >![Add a condition](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/hana-cloud-alerts-custom/conditional.png)

2. Create an action.

    ![create an action](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/hana-cloud-alerts-custom/create-action.png)

3. Specify the type of action to be Email.

    ![email action](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/hana-cloud-alerts-custom/create-action-email.png)

    See also [Managing Actions](https://help.sap.com/viewer/5967a369d4b74f7a9c2b91f5df8e6ab6/Cloud/en-US/8a7e092eebc74b3ea01d506265e8c8f8.html) for details on other available action types.

4. Provide the Name `email-manager`.

    ![email action details](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/hana-cloud-alerts-custom/create-action-email-details.png)

     Scroll to the Additional Properties section.

    ![advanced action details](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/hana-cloud-alerts-custom/create-action-email-details-advanced.png)

    Specify the values below.

    | Label | Value |
    | ----- | ----- |
    | Email Address | *your email address* |
    | Subject Template | `{subject}` |
    | Payload Template | `{body}` |

5. A confirmation token will be sent to the email address.  Click on the provided link or copy confirmation token and use it to confirm the action as shown in the next sub-step.

    ![email with confirmation token](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/hana-cloud-alerts-custom/ans-sub-action-type-email-confirm0.png)

6. Click on **`email-manager`** to open it.

    ![confirm email address](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/hana-cloud-alerts-custom/ans-sub-action-type-email-confirm.png)

    Press the Confirm Action button.

    ![confirm email address](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/hana-cloud-alerts-custom/ans-sub-action-type-email-confirm2.png)

    Enter the confirmation token and notice that the action is now enabled.

    ![email action enabled](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/hana-cloud-alerts-custom/ans-sub-action-type-email-enabled.png)

7. Create a subscription.

    ![subscriptions](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/hana-cloud-alerts-custom/ans-sub.png)

    Provide a value for the name and press the Create button.

    ![Add a subscription](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/hana-cloud-alerts-custom/ans-sub-create.png)

8. Assign the condition and action to the subscription.

    ![assigned condition and action](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/hana-cloud-alerts-custom/subscription-summary.png)

9. In the SAP Automation Pilot, trigger the command and notice that an email is now sent.

    ![email notification](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/hana-cloud-alerts-custom/email-notification.png)



### Scheduling commands
In this step, the command will be scheduled to run once a week.  

1. In the SAP Automation Pilot, select Scheduled Executions and press the Schedule button.

    ![schedule](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/hana-cloud-alerts-custom/schedule.png)

    Specify the values below.

    | Label | Value |
    | -------- | ----- |
    | Command | `CheckMaintenanceItems` |
    | Schedule | `Weekly`|
    | Weekdays | `Monday`|
    | Hours | `12`|
    | Minutes | `0`|

    ![scheduled](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/hana-cloud-alerts-custom/scheduled.png)

    Additional details can be found at [Scheduled Execution](https://help.sap.com/docs/AUTOMATION_PILOT/de3900c419f5492a8802274c17e07049/96863a2380d24ba4bab0145bbd78e411.html).

2. Provided commands such as `StopHanaCloudInstance` and `StartHanaCloudIntance` can also be scheduled perhaps to shut down and restart a development SAP HANA Cloud instance on weekends.  The `StopHanaCloudInstance` command is shown below.

    ![stop HANA Cloud command](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/hana-cloud-alerts-custom/automation-pilot.png)


### Knowledge check
Congratulations! You have now used the SAP Automation Pilot to schedule a query against an SAP HANA Cloud database and to send a notification that reflects the result of the query.


---