Scheduled Transformations
Transformations can be configured to run automatically on a schedule. This is used for recurring tasks such as nightly data imports, weekly compliance calculations, periodic notifications, and integration synchronization.
Viewing Scheduled Transformations
Navigate to Admin > Transformations > Scheduled Transformations to see all transformations with an active schedule.
Creating a Schedule
To schedule a transformation:
- Navigate to Admin > Transformations
- Open the transformation you want to schedule
- Click the Schedule tab
- Set the schedule parameters:
| Field | Description |
|---|---|
| Enabled | Check to activate the schedule |
| Frequency | How often to run: Daily, Weekly, Monthly |
| Time | The time of day to run (server local time) |
| Day of Week | For weekly schedules, which day to run |
| Day of Month | For monthly schedules, which day to run |
- Save the transformation
How Scheduled Jobs Run
Scheduled transformations are managed by the xAssets Batch Service (a Windows service running on the server):
- The batch service checks for due schedules every few minutes
- When a schedule is due, it launches the transformation as a batch job
- The batch job runs in the background — progress is visible in Admin > Batch > Batch Jobs
- On completion, the status updates to Completed or Failed
Common Scheduled Tasks
| Task | Typical Schedule | Transformation Type |
|---|---|---|
| Discovery data load | Every 15 minutes or hourly | System transformation |
| Active Directory user sync | Daily at 2:00 AM | AMSX integration script |
| Software compliance calculation | Weekly on Monday | System transformation |
| Warranty expiry notifications | Weekly on Friday | AMSX notification script |
| Data export to finance system | Monthly on 1st | AMSX integration script |
| Database maintenance | Weekly on Sunday | System transformation |
Troubleshooting Schedules
If a scheduled job is not running:
- Check that the batch service is running (Windows Services > xAssets Batch Service)
- Verify the schedule is Enabled on the transformation
- Check the Batch Jobs list for any failed previous runs
- Ensure the server clock is correct — schedules use server local time
- Check that the transformation itself works when run manually before scheduling it
Tip: When first setting up a schedule, use a short interval (e.g., run it in 5 minutes) to verify it fires correctly before configuring the final schedule. Check the Batch Jobs list to confirm it ran and completed successfully.
Related Articles
- Batch Jobs — viewing and managing batch jobs
- Integration and Data Operations with Transformations — the transformation system