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