Creating Text Index Jobs and Job Schedules

Before you being this procedure, check the database login for connecting to the data area’s database when executing textindexjob. This login must have privileges to add and drop jobs, job steps, and job schedules.

The textindexjob utility generates and executes SQL to drop and create jobs to populate text indexes in Microsoft SQL Server. The text index job utility defines a schedule for populating a text index based on parameters settings in the db.cfg file. For more information on text indexing and the db.cfg file, see the Infor Landmark Technology Data Access Using Microsoft SQL Server guide.

At a Landmark command prompt, type

textindexjob [-Uqdc] DataArea [FileName|ModuleName ...]

Consider the following


Option	Description
`DataArea`	The data area where text index job should be processed.
`ModuleName`	Process text index jobs for all files in the module.
`FileName`	Process a text index job for this file. Note: Use module or file name, but not both.
`-U`	Perform the actions on database.
`-q`	Do not print DDL to stdout.
`-d`	Drop the selected jobs.
`-c`	Create the selected jobs.