Job Management Partner 1/Software Distribution Description and Planning Guide

[Contents][Glossary][Index][Back][Next]

Appendix C.63 netmdm_schedule

This table stores the schedule of a registered job.

Column name Oracle Microsoft SQL Server Embedded RDB Description Key No.
Data type Size Data type Size Data type Size
dm_jobname VARCHAR2 32 varchar 32 MVARCHAR 32 Scheduled job name --
dm_jobschnum VARCHAR2 64 varchar 64 MVARCHAR 64 Scheduled job number#:
  • Jsxxxxxxxxxxxxxx: Job registration schedule
  • Jrxxxxxxxxxxxxxx: Client job deletion schedule
  • Jdxxxxxxxxxxxxxx: Job deletion schedule
  • Jgxxxxxxxxxxxxxx: Job definition deletion schedule
  • Jexxxxxxxxxxxxxx: Job execution schedule
1
dm_eventtime DATE -- datetime 8 TIMESTAMP -- Schedule execution date/time --
dm_limittime DATE -- datetime 8 TIMESTAMP -- Schedule execution time limit --
dm_executetime DATE -- datetime 8 TIMESTAMP -- Schedule registration date/time --
dm_systeminf BLOB -- image -- BLOB -- JP1/Software Distribution Manager management information --

--: Not applicable. xxxxxxxxxxxxxx: Job number.


#
For an ID group job, the number begins with I, not J.