Database Mapper Scheduling a Snapshot
With SolarWinds Database Mapper, you can schedule snapshots to occur at a time of your choosing. This can be useful for automating the snapshot process, and to continually update documentation for your data sources at consistent intervals. For example, you may want to schedule a snapshot weekly for a dev server to document the changes that occur on a weekly basis.
Additional Information: For information about:
- Manually starting a snapshot, and generating documentation for the first time, see the Generating Documentation article
- Creating a solution, and adding solution items, see the Solutions and Solution items articles
To begin scheduling a snapshot for your selected remote agent, complete the following steps:
1. Open the Solutions dashboard, and select the Configure Snapshot button for the desired solution to open the Snapshot Configuration window. Copy the first snapshot command.
2. Open the Database Mapper install directory, select SHIFT+ Right Click to open the context menu, and then select the Open PowerShell window here option.
Note: In this example, the install directory is C:\Program Files (x86)\SentryOne\Database Mapper Remote Agent. Database Mapper uses this by default.
3. Paste and execute the copied command. Go back to Database Mapper, then copy the second snapshot command.
Note: You only need to copy the argument. You don't need to copy the whole statement including the .exe.
Important: You need to copy the argument starting with the word snapshot through the end of the argument. For example, you would only copy the highlighted portion as shown in the snapshot configuration image above. The code snippet provided below is only an example:
snapshot -s e42684e9-f8aa-4881-9915-26443a852f9f -t https://s1dhost-dev-eus-as.azurewebsites.net/ -o 6d1ff543-dec2-47dc-8a1b-965038adcbc6
4. Open Windows Task Scheduler and select Action > Create basic Task to open the Create Basic Task Wizard.
5. Enter a name and description. Select Next to continue.
6. Select a task starting point and select Next. Configure your trigger, then select Next to continue.
7. Select Start a program for the action, then select Next. Select Browse to open remote agent install directory, then select the SentryOneCommandLine.exe. Paste the previously copied Snapshot Configuration command in the Arguments box. Select Next to continue.
Important: You need to paste the argument that you copied in Step 3 in the Add arguments (optional) field. For example, you would only paste the highlighted portion as shown in the snapshot configuration image in Step 3. The code snippet provided below is only an example:
snapshot -s e42684e9-f8aa-4881-9915-26443a852f9f -t https://s1dhost-dev-eus-as.azurewebsites.net/ -o 6d1ff543-dec2-47dc-8a1b-965038adcbc6
8. Select Finish to save your task.
Success: Your Database Mapper Snapshot is now scheduled!