SI_SCHEDULE_STATUS Property

Applies To  

The current status of the scheduled job. Indexed. Read-Only.

SI_SCHEDULE_STATUS is the recommended property to access scheduling information. It combines the values for SI_INSTANCE_OBJECT and SI_RUNNABLE_OBJECT into a status value.
SI_SCHEDULE_STATUS SI_INSTANCE_OBJECT SI_RUNNABLE_OBJECT

no schedule status

false

false

pending

false

true

running

false

true

success/failure

true

false

Type

Long

Syntax

SELECT

    SI_SCHEDULE_STATUS

FROM

    CI_INFOOBJECTS

WHERE

    SI_ID=ObjectID

The syntax has these parts:

Part Type Description

ObjectID

Long

A number that identifies the object you want to retrieve.

Used to access the property from a query result:

QueryResult.Item(Index).SchedulingInfo.Status

Remarks

The values for SI_SCHEDULE_STATUS are mapped to CeScheduleStatus.

If a report is not scheduled, it will not have a SI_SCHEDULE_STATUS. Therefore, you cannot recurse through reports, as they won't all necessarily have this property. Instead, to recurse through the reports, use the mapping:

SI_INSTANCE Property = TRUE And SI_RUNNABLE_OBJECT Property = FALSE



Crystal Decisions, Inc.
http://www.crystaldecisions.com
Support services:
http://support.crystaldecisions.com