Download Confirm Task Processor - Reference.mapinfo.com
Transcript
Confirm Task Processor Step 1: Creating the Script. • Copy the Task Processor - Database Configuration folder to the local drive from Resources folder within Confirm media. • Ensure following files exist in the same folder: 1. 2. 3. 4. Create Database Script.bat MSSQL File1.txt MSSQL File2.txt MSSQL File3.txt • • • • Launch 'Create Database Script.bat' batch file. Enter 2 when prompted for type of database. Enter Confirm Database name when prompted. Enter Schema Name in Uppercase. Each dataset of Confirm corresponds to a Schema in the database. • Enter Schema Login Name (schema/asset owner) that corresponds to Schema. • Repeat above two steps if you have more than one Confirm dataset installed. • The script is not to be run against SBS schema. The screen shot below is an example of how the entries may look like: The batch file will create a sql script named '_Output Database Script.sql' in the location where the batch file exists. Note: For Microsoft SQL Server versions from 2008SP1 to 2008SP3, please contact Pitney Bowes Support for database scripts. Step 2: Running the Script. • Login into the database with DBA permissions. • Open script '_Output Database Script.sql'. • Run the script. In case more than one connections are open, you'll get the following error: "Detected existing connections. Ensure all other connections are dropped before executing this script." To resolve, close all existing connections and run the script again. • Logout from the database. The scripts will create following jobs which needs to be enabled from within the database. • job_TaskMaintenance_<Database Name>_<SCHEMA NAME> • job_TaskScheduler_<Database Name>_<SCHEMA NAME> Pitney Bowes 8 of 41