Issue
Database jobs are periodically run using scheduled tasks. These tasks can also be run manually via the PowerShell scripts which may aid in troubleshooting as the PowerShell console may give additional errors on why the tasks were originally failing. This article describes the alternative method used to manually run the tasks.

Product Line

Power Monitoring Expert 8.x

Power Monitoring Expert 9.x

Power Monitoring Expert 2020

Power Monitoring Expert 2021

Power Monitoring Expert 2022

Power Monitoring Expert 2023

Power Monitoring Expert 2024

Environment
Windows PowerShell

Cause
Provides a better understanding on the database tasks and a way of trouble shooting in case of issues.

Resolution
Supporting Files
The supporting files are located in ...\config\cfg\dbscheduledtasks\support\ folder and are used by the script files; they are not to be run by themselves.

The one of importance is Configuration.ps1 which has the following three parameters and values:
$locationForBackupFiles = "cfg\DBBackups\"
$databaseSizeNotificationThresholdPercentage = 85
$diagnosticsDaysToKeep = 30

Script Files
There are four script files and they are located in ...\config\cfg\dbscheduledtasks\ folder.
Each script file requires a database name to be passed as a parameter.  This is identified by opening the file and observing the first line:
param($databaseIdentifier)

How to Manually Execute a Tasks
Note: Powershell is required for manual execution of the scripts.

1. Open Powershell
   • Click Start and search for 'Windows PowerShell (x86)'
   • Right-click on 'Windows PowerShell (x86)' (Note: Be sure to open the (x86) version of PowerShell)
   • Select Run as administrator.
2. Navigate to the \Power Monitoring Expert\config\cfg\DbScheduledTasks directory within PowerShell
   • Locate the exact location of the DbScheduledTasks directory using Windows Explorer
   • Use the change directory command, cd, to change to the DbScheduleTasks directory

3. Once in the proper directory, run the command corresponding to the desired database task. The tables below contain the commands and required database parameters required to run the script manually.

Backup.ps1

DatabaseMaintenance.ps1

DatabaseSizeNotification.ps1

TrimDiagnostics.ps1

Released for: Schneider Electric Canada