select * from wcuser.SCHEDULEITEM

CANCELLED | CLASSNAMEKEYDOMAINREF | IDA3DOMAINREF | EVENTSET | IMMEDIATEMODE | INHERITEDDOMAIN | ITEMDESCRIPTION | ITEMNAME | NEXTTIME | PERIODICITY | PRINCIPALREFISNULL | CLASSNAMEKEYA5 | IDA3A5 | CLASSNAMEKEYB5 | IDA3B5 | QUEUENAME | RUNCOUNT | STARTDATE | TARGETCLASS | TARGETMETHOD | CREATESTAMPA2 | MARKFORDELETEA2 | MODIFYSTAMPA2 | CLASSNAMEA2A2 | IDA2A2 | UPDATECOUNTA2 | UPDATESTAMPA2 | TOBERUN
0 | wt.admin.AdministrativeDomain | 2003 | null | 0 | 0 | Removes from persistence wt.eff.EffChangeAudit objects that are no longer referenced. | purgeOrphanedEffAudits | 2006-10-25 23:47:01.0 | 86400 | 0 | wt.org.WTUser | 2006 | wt.queue.ScheduleQueueEntry | 2154 | PurgeOrphanedEffAuditsQueue | 40 | 2006-07-09 23:47:01.0 | wt.eff.StandardEffService | purgeOrphanedEffAudits | 2006-07-09 23:47:02.0 | 0 | 2006-10-25 01:45:44.0 | wt.scheduler.ScheduleItem | 2153 | 82 | 2006-10-25 01:45:44.0 | -1
0 | wt.admin.AdministrativeDomain | 2003 | null | 1 | 0 | test2 | t2 | 2006-10-01 04:45:47.0 | 0 | 0 | wt.org.WTUser | 2006 | null | 0 | WVSScheduleQueue | 1 | 2006-10-01 04:45:47.0 | com.ptc.wvs.server.schedule.ScheduleJobs | doBatchJob | 2006-10-01 04:44:47.0 | 0 | 2006-10-01 04:45:52.0 | wt.scheduler.ScheduleItem | 44067 | 4 | 2006-10-01 04:45:52.0 | 1
0 | wt.admin.AdministrativeDomain | 2003 | null | 1 | 0 | test2 | t2 | 2006-10-01 04:46:14.0 | 0 | 0 | wt.org.WTUser | 2006 | null | 0 | WVSScheduleQueue | 1 | 2006-10-01 04:46:14.0 | com.ptc.wvs.server.schedule.ScheduleJobs | doBatchJob | 2006-10-01 04:45:14.0 | 0 | 2006-10-01 04:46:17.0 | wt.scheduler.ScheduleItem | 44076 | 4 | 2006-10-01 04:46:17.0 | 1
0 | wt.admin.AdministrativeDomain | 2003 | null | 1 | 0 | null | t3 | 2006-10-01 16:14:14.0 | 0 | 0 | wt.org.WTUser | 2006 | null | 0 | WVSScheduleQueue | 1 | 2006-10-01 16:14:14.0 | com.ptc.wvs.server.schedule.ScheduleJobs | doBatchJob | 2006-10-01 16:13:14.0 | 0 | 2006-10-01 16:14:20.0 | wt.scheduler.ScheduleItem | 45114 | 4 | 2006-10-01 16:14:20.0 | 1
0 | wt.admin.AdministrativeDomain | 2003 | null | 0 | 0 | Clean up of unreferenced filevault items | purgeUnreferencedFvItems | 2006-10-26 01:45:17.0 | 86400 | 0 | wt.org.WTUser | 2006 | wt.queue.ScheduleQueueEntry | 79806 | PurgeUnreferencedFvItemQueue | 1 | 2006-10-25 01:45:17.0 | wt.fv.StandardFvService | purgeUnreferencedFvItems | 2006-10-25 01:45:17.0 | 0 | 2006-10-25 01:45:44.0 | wt.scheduler.ScheduleItem | 79801 | 4 | 2006-10-25 01:45:44.0 | -1
0 | wt.admin.AdministrativeDomain | 2003 | null | 1 | 0 | null | p10 | 2006-10-02 06:14:26.0 | 0 | 0 | wt.org.WTUser | 18147 | null | 0 | WVSScheduleQueue | 1 | 2006-10-02 06:14:26.0 | com.ptc.wvs.server.schedule.ScheduleJobs | doBatchJob | 2006-10-02 06:13:26.0 | 0 | 2006-10-02 06:14:26.0 | wt.scheduler.ScheduleItem | 46127 | 4 | 2006-10-02 06:14:26.0 | 1
0 | wt.admin.AdministrativeDomain | 2003 | null | 1 | 0 | publish 1 | p1 | 2006-10-01 03:45:44.0 | 0 | 0 | wt.org.WTUser | 2006 | null | 0 | WVSScheduleQueue | 1 | 2006-10-01 03:45:44.0 | com.ptc.wvs.server.schedule.ScheduleJobs | doBatchJob | 2006-10-01 03:44:44.0 | 0 | 2006-10-01 03:45:51.0 | wt.scheduler.ScheduleItem | 43722 | 4 | 2006-10-01 03:45:51.0 | 1
0 | wt.admin.AdministrativeDomain | 2003 | null | 0 | 0 | Clean up of old HTML log messages | purgeOldHMTLLogMessages | 2006-10-25 06:04:17.0 | 86400 | 0 | wt.org.WTUser | 2006 | wt.queue.ScheduleQueueEntry | 66526 | PurgeHTMLLogMessageQueue | 9 | 2006-10-15 06:04:17.0 | com.ptc.windchill.cadx.common.htmllog.HTMLLogServerHelper | purgeOldHMTLLogMessages | 2006-10-15 06:04:17.0 | 0 | 2006-10-24 06:04:17.0 | wt.scheduler.ScheduleItem | 66525 | 20 | 2006-10-24 06:04:17.0 | -1
0 | wt.admin.AdministrativeDomain | 2003 | null | 0 | 0 | Clean up of old History items | purgeOldHistories | 2006-10-26 01:45:20.0 | 86400 | 0 | wt.org.WTUser | 2006 | wt.queue.ScheduleQueueEntry | 79805 | PurgeScheduleHistoryQueue | 1 | 2006-10-25 01:45:35.0 | wt.scheduler.StandardSchedulingService | purgeOldHistories | 2006-10-25 01:45:35.0 | 0 | 2006-10-25 01:45:46.0 | wt.scheduler.ScheduleItem | 79802 | 4 | 2006-10-25 01:45:46.0 | -1