►►─ EXECUTE PACkage ─ package-id ──────────────────────────────────────────────►
►─┬───────────────────────────────────────────────────────────────────────┬─ . ─►◄
└ OPTions ─ ¤ ┬───────────────────────────────────────────────────┬─ ¤ ─┘
│ ┌───── OR ───────┐ │
│ │ │ │
├ WHEre PACkage STATus ─┬────┬ ▼ ┬ APPROVED ◄ ─┬┴───┤
│ └ IS ┘ └─ EXECFailed─┘ │
└ EXECUTIon WINdow ─┤ FROM TO ├ ────────────────────┘
Expansion of FROM TO
├── FROmfrom-datefrom-timeTOto-dateto-time ────────────────────────────────────┤
EXECUTE PACKAGE package-id
The EXECUTE PACKAGE clause identifies the package you want to execute. You can use a fully specified, partially wildcarded, or fully wildcarded package ID. When the package-id is fully specified, the WHERE PACKAGE STATUS clause will be ignored and the parser will issue a warning message.
OPTIONS
OPTION clauses allow you to further specify action requests.
EXECUTION WINDOW FROM from-date from-time TO to-date to-time
Specifies the time frame within which to execute the package. Specify date values in DDMMMYY format and the time values in HH:MM format. If you specify the from-date, you must also specify the from-time. If you specify the to-date, you must also specify the to-time. You can only use the EXECUTION WINDOW clause if the package is fully qualified and the existing execution window is closed.
WHERE PACKAGE STATUS
Specifies the statuses of the packages you want to execute. You can only use this clause when you wildcard the package-id. The default is to execute packages that have a status of Approved. Use the WHERE PACKAGE STATUS IS EXECFAILED clause to re-execute packages that have previously failed. Use the OR clause to indicate that packages of either status should be executed.
Example: Execute Package SCL
The following is an example of EXECUTE PACKAGE SCL. The SCL executes the package called PAYROLLPKG01.
EXECUTE PACKAGE PAYROLLPKG01.
|
Copyright © 2014 CA Technologies.
All rights reserved.
|
|