Siebel Marketing Installation and Administration Guide > Installing and Administering Segmentation and List Generation > Setting Up Marketing Module Parameters in Siebel Analytics >

Managing Marketing Jobs

The Manage Marketing Jobs console allows you to view the status and details of each segmentation or list generation request running on the Analytics Web Server. To view the details of a request, click the Details link in the Action column for the job.

You can also view the current database cache for any Qualified List Items accessed by a segment or segment tree request. To view the details for the cache, click Details in the Action column for the cache entry. To purge the cache, click the Purge link in the Action column for the cache entry.

NOTE:  The Purge link next to each cache entry row purges all existing cache entries for the user who created the entry.

To view marketing jobs

1. From the Site Map, choose Administration - Marketing > Marketing Server Admin.
2. In the Siebel Analytics Administration page, click Manage Marketing Jobs.
3. The top section displays all marketing jobs. The bottom section displays cache entries. The following list describes the types of marketing jobs.

   Marketing Job	Description
   Get Counts	Represents a segment or segment tree count submitted through the Segment Designer, Segment Tree Designer, or SOAP API. For the Segment Designer, a count request within the Edit Criteria Block dialog box appears. The name of the segment or tree is always displayed in the information column.
   Write List Files	Represents a list generation job for full output list generation or preview. The information field contains the list format name as well as the location where the output files are written.
   Write Saved Result Set	Represents the saving of either a segment result set or a segment tree cell result set. The name of the segment or tree is always displayed in the information column.
   Delete Saved Result Set	Represents the deleting of a segment result set. The name of the segment or tree is always displayed in the information column.
   Purge Cache	Represents the user action of deleting cache result sets. This job type includes purging all cache in the system, purging all cache for a specific user, purging cache for a specific segment and purging cache for a specific tree.

Using Job Action Links

The following is a list of action links:

• Cancel. All marketing jobs can be cancelled by clicking the Cancel action link. If a job is in the middle of a long-running operation, such as running a set of Siebel Analytic Server queries, the job issues SQLCancels to cancel all queries. While the Analytics Server is processing the cancel, the job state shows Running (Cancelling). After all queries have been cancelled, the job state updates the value to Cancelled.
• Cancel All. Cancels all running jobs in the system.
• Detail. Each job record also includes a Detail link which includes real-time information about the progress of the job. This log contains basic job statistics as well as detailed information specific to the job.
  • For count, write saved result set, and write list file jobs, the log includes the query plan used to generate the logical SQL and SQL results and timings.
  • For delete saved result sets, the log includes the logical delete statements on the header and data tables.
  • For write list files, the log includes the constrained list items qualified by the list and the list SQL.