The Database category contains jobs relating to SQL and the DriveWorks Group.
These jobs will send an email when run successfully.
The jobs available in this category are:
This job will monitor the Group Database and returns its size.
This is useful for taking actions, such as deleting reports, before the maximum database size is reached.
Uses the Mail Server settings applied in DriveWorks Autopilot to send job notifications.
| Name | Description | Example |
|---|---|---|
| Email Sender | A valid email address for the sender of the email. | DriveAppScheduler@MyCompany.com |
| Email Recipient | A valid email address for the recipient of the email. | admin@MyCompany.com |
| Email CC | A valid email address for additional recipients of the email. | admin2@MyCompany.com
Multiple recipients can be included by separating each address with a pipebar: admin2@MyCompany.com|admin3@MyCompany.com |
| Autopilot Tag | The name of the Autopilot Tag that targets the DriveWorks Autopilot machine to process the Job from.
See DriveWorks Autopilot - Edit Tags for more information. | TagName |
| Name | Description | Example |
|---|---|---|
| DriveWorks Group SQL Instance Name | The Name of the DriveWorks Group SQL Instance to Query | SERVER-DB\SQLExpress |
| Database Login Method | The method of connection, this can either by the specific windows user of the Autopilot machine or the DriveApp connection declared when creating the DriveApp. | DriveApp Credentials OR Windows Authentication |
| Current Values (MB) | This allows you to see the current state, in case you didn't want to run the task or you needed a benchmark. | N/A |
| Alert Values (MB) | The set of values you want to be alerted when the size is larger than. | 80 (This equates to 80MB) |
This job allows you to run your own custom SQL query on a schedule. You simply paste the query into the job and tell it where to run.
Uses the Mail Server settings applied in DriveWorks Autopilot to send job notifications.
| Name | Description | Example |
|---|---|---|
| Email Sender | A valid email address for the sender of the email. | DriveAppScheduler@MyCompany.com |
| Email Recipient | A valid email address for the recipient of the email. | admin@MyCompany.com |
| Email CC | A valid email address for additional recipients of the email. | admin2@MyCompany.com
Multiple recipients can be included by separating each address with a pipebar: admin2@MyCompany.com|admin3@MyCompany.com |
| Autopilot Tag | The name of the Autopilot Tag that targets the DriveWorks Autopilot machine to process the Job from.
See DriveWorks Autopilot - Edit Tags for more information. | TagName |
| Name | Description | Example |
|---|---|---|
| Server Name | The name of the SQL instance to connect to. | SERVER-DB\SQLExpress |
| Database Name | The name of the Database to run the query inside. | MyDatabaseName |
| Database Login Method | Decide the method of connection, this can either by the specific windows user of the Autopilot machine or the DriveApp connection declared when creating the DriveApp. | DriveApp Credentials OR Windows Authentification |
| Query | The query that you want to run. | EXEC GetLatestView |
Learn more about the functionality that powers these jobs.