Skip to main content

Refresh Jobs

Refresh Jobs are scheduled processes that pull updated data from external sources into Point. They keep your investment data current by automatically fetching prices, FX rates, positions, and transactions from banks, custodians, and market data providers.

Viewing Refresh Jobs

Navigate to Data Quality → Refresh Jobs to see all configured jobs.

Job List Columns

ColumnDescription
Job NameA descriptive name for the job
Data TypeWhat type of data the job fetches (Prices, FX Rates, Positions, Transactions)
SourceThe external system the job connects to
ScheduleWhen the job runs (e.g., Daily at 18:00 UTC)
Last RunDate and time of the most recent execution
StatusSuccess ✅, Warning ⚠️, Failed ❌, Running 🔄, Pending ⏳
Records ProcessedNumber of records imported in the last run

Job Statuses

StatusMeaningAction Required
SuccessJob completed successfullyNone
⚠️ WarningJob completed but with some issuesReview the job log
FailedJob did not completeInvestigate and resolve
🔄 RunningJob is currently executingWait for completion
PendingJob is scheduled but hasn't run yetNone

Running a Job Manually

If you need data updated immediately (e.g., before generating a report):

  1. Find the job in the list
  2. Click the Run Now button (▶ icon)
  3. Confirm the manual run
  4. The job status will change to 🔄 Running
  5. Refresh the page to see the updated status
When to Run Manually

Manual runs are useful when:

  • You need up-to-date data before a client meeting
  • A scheduled run failed and you've resolved the underlying issue
  • You've added new data sources and want to do an initial load

Job Logs

To see the detailed log for a specific job run:

  1. Click on the job name
  2. Select the Run History tab
  3. Click on any historical run to see its log

The log shows:

  • Start and end time
  • Number of records fetched, processed, and rejected
  • Any errors or warnings with details
  • The data source's response codes

Common Failure Reasons

Failure ReasonHow to Resolve
Authentication failureCheck that the API credentials for the data source are still valid
Connection timeoutThe external source was unavailable — retry later or contact the source
Data format errorThe source sent data in an unexpected format — contact support
Duplicate recordsThe source sent data that already exists — usually safe to ignore
Validation failureData failed Point's validation rules — review the specific records in the log

Configuring New Jobs

To add a new refresh job, contact your administrator or support@pointgroup.io. Setting up a new job requires:

  • Access credentials for the data source
  • The data format specification
  • The desired schedule
  • Mapping rules (how the source data maps to Point's data model)