dsmithson/runsmart-sqljobrunner repository overview

This container runs the RunSmart SQL Job Runner service. This service replaces SQL agent jobs normally running on SQL server, which are unavailable in some cloud or container hosted environments.

Starting with version 3.7-1.3, prometheus endpoint monitoring has been added and is exposed on port 9998. Expose this port (see example below) and browse to http://:9998/metrics to view available metrics.

⁠Supported Enivronment Variables

• SQL_SERVER_Name: IP address or hostname of the Microsoft SQL server running the RunSmart database
• SQL_DB_NAME: (Optional) Database name on SQL Server. Defaults to IODC_Central if not specified
• SQL_USER: Username to log into RunSmart database. This may likely be SA or some other admin level account
• SQL_PASS: Password for user used to log into RunSmart database

⁠Example Run Syntax

docker run -it -e SQL_SERVER_NAME='192.168.1.100 -e SQL_USER=sa -e SQL_PASS=MySuperSecretPassword -p 9998:9998 dsmithson/runsmart-sqljobrunner