Home Search

DriveWorks Pro 21
Database Jobs

Send Feedback

Database Jobs

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:

Group Database Size Monitor

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.

Email Details

Uses the Mail Server settings applied in DriveWorks Autopilot to send job notifications.

NameDescriptionExample
Email SenderA valid email address for the sender of the email.DriveAppScheduler@MyCompany.com
Email RecipientA valid email address for the recipient of the email.admin@MyCompany.com
Email CCA 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 TagThe 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

Job Inputs

NameDescriptionExample
DriveWorks Group SQL Instance Name The Name of the DriveWorks Group SQL Instance to Query SERVER-DB\SQLExpress
Database Login MethodThe 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)

Run SQL Query

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.

Email Details

Uses the Mail Server settings applied in DriveWorks Autopilot to send job notifications.

NameDescriptionExample
Email SenderA valid email address for the sender of the email.DriveAppScheduler@MyCompany.com
Email RecipientA valid email address for the recipient of the email.admin@MyCompany.com
Email CCA 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 TagThe 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

Job Inputs

NameDescriptionExample
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

Technology

Learn more about the functionality that powers these jobs.