select * from wcuser.SCHEDULEITEM

Connect time(ms): 62

Connected to jdbc:oracle:thin:@LarrySERVER:1521:wind
Driver       Oracle JDBC driver
Version      8.1.7.1.0

Query time & data xfer(ms): 16

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||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||1|0|test2|t2|2006-10-01 04:45:47.0|0|0|wt.org.WTUser|2006||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||1|0|test2|t2|2006-10-01 04:46:14.0|0|0|wt.org.WTUser|2006||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||1|0||t3|2006-10-01 16:14:14.0|0|0|wt.org.WTUser|2006||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||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||1|0||p10|2006-10-02 06:14:26.0|0|0|wt.org.WTUser|18147||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||1|0|publish 1|p1|2006-10-01 03:45:44.0|0|0|wt.org.WTUser|2006||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||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||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

