| KB Id: | 7595 | Create Date: | 1/8/2009 9:32:21 AM |
|---|---|---|---|
| Subsystem: | Mask: | ||
| Version: | Service Pack: | ||
| DB Type: | DB Version: | ||
| OS Type: | OS Version: | ||
| Author: | BRADH | Last Revised: | 1/8/2009 9:32:21 AM |
| Details: |
|---|
| The data dictionary only lists OK, IP, and FL as possible values in the us_jlog_status field of the us_jlog_dtl table, but we have other values such as SY and FN. This KB will explain those newer values. |
The data dictionary only lists OK, IP, and FL as possible values in the us_jlog_status field of the us_jlog_dtl table, but we have other values such as SY and FN. What are these values? The values in the us_jlog_status field denote a two character message.
The first character indicates whether the job ran successfully or not: S = Success, F = Failed
The second character indicates whether the user that ran the job was notified or not: Y = Notified, N (or blank) = Not Notified
Therefore, if the value was SY, for example, this would indicate that the job ran successfully and the user was notified.