Smarticket Database Manager dialog box

Use this dialog box to enter database connection parameters, create databases and set-up database maintenance activities.

Note: Creating, modifying, or updating the database system require logon information for a database system user that has create and update permissions

Database Setup tab

Option Description
Database tab Use this form to create a new Smarticket database or upgrade from a previous version.

Choose Create new to create a new database or Update existing to upgrade an existing database. You can click the Copy from Database User tab hyperlink to copy the information entered on the Database User tab into the options on this tab.

  • DBMS — The name for database management server. This entry cannot be edited.
  • Server — Enter the IP address or server name for the database management server.
  • Database — Enter the name of the database.

If you chose the Create new option, click the Create Database button. If you chose the Upgrade existing, click the Upgrade Database button.

Database User tab Configure options on this tab to ensure the login for the Smarticket database exists. You can click the Copy from Database tab hyperlink to copy the information entered on the Database tab into options on this tab.
  • DBMS — The name for database management server. This entry cannot be edited.
  • Server — Enter the IP address or server name for the database management server.
  • Database — Enter the database name.
  • Smarticket Login Id/User Id — Enter the database user credentials for the database management server and database.
  • Password — Enter the password for the database user.
Verify Login/User Click this button to test that the database and user settings are valid.

Database Maintenance tab

Settings for the Database Maintenance Service can be configure on this tab. The editable settings for the service are can also be configured in the Settings console in the Windows Administrative Tools.

Option Description
Status The status can be one of the following:
  • Starting — The service is starting.
  • Running — The service has been started and is running.
  • Stopping — The service is stopping.
  • Stopped — The service has been stopped and is not running.
Start Click this button to start the service. This button is available when the service is stopped.
Stop Click this button to stop the service. This button is available when the service is running.
Options Click this button to open the Smarticket Database Manager Service Properties dialog box to configure the service properties. For details, see Smarticket Database Manager Service Options.
Job Maintenance
  • Delete Expired Jobs — Select this check box to delete all expired maintenance jobs.
  • Schedule — Click this button to change the job deletion schedule.
  • Delete Now — Deletes all expired maintenance jobs immediately without the use of the scheduling mechanism.
Notification Maintenance
  • Delete Notifications older than — Select this check box to delete all notification older than the specified number of days (1-99).
  • Schedule — Click this button to change the notification deletion schedule.
  • Delete Now — Deletes all expired notifications immediately without the use of the scheduling mechanism.