Skip to main content

Data Update Job

The Data Update Job is a daily recurring SQL job that processes the information in the SnowInventory (SNOWDB for Snow Inventory 3) database into a more SAM usable format. It re-populates the SLM database with new and updated inventory information, applies software recognition rules, and calculates usage, compliance, and alerts. In addition to the scheduled occurrence, the job can be run manually as well.

How the Data Update Job gathers data depends on how the inventory sources are configured. For more information, see Supported configurations.

The Data Update Job view shows action, status, and scheduling information for the process. The action details of the Data Update process are logged, making it easy to troubleshoot and locate bottlenecks. If an error has occurred, the log can be used to locate where the job stopped and what the cause was.

The Execution Time column shows the time it took to finish the action including any sub-actions. The Message column shows changes or updates that have been made or error messages in case of an error.

Note

When the Data Update Job runs, users are not allowed access to the platform. Users logged in to the SLM Web UI are prompted with a message, including an approximate finish time for the job, and will automatically be logged out.

Start Data Update Job manually

To run the Data Update Job outside of the schedule, click Start update job manually in the lower part of the window. All current users of the SLM Web UI will be logged out from the system when the Data Update Job is executing.

Schedule Data Update Job

To manage the scheduling of the Data Update job, click Schedule.

In the Frequency section, use the Occurs list to select the frequency for the update job. Available recurrence settings depend on the selected frequency.

In the Time settings section, use the Occurs at list to select time of day for the update job.

Data Update Job log

To display information about the different logs created during a scheduled job, click Update log.

The Current Job Log tab shows log information on the last scheduled job.

The Job Log History tab shows log information on historical jobs. Select a date from the Select Job list.

To export a job log, click Export at the bottom of the page. Available export formats are Excel, PDF, XML, and Text file.