Delete Submitted Jobs

Hi JDEList
During the testing, we submitted a lot of jobs using scheduler(in thousands). Now I want to delete all the jobs. So I ran the job R91300b to perge the jobs. It perged the jobs from scheduler that are either completed or launched.
But Now I see a lot of jobs in the Job Master(P986110B) with status=waiting and as soon as I start the JDE services on the Enterprise server, these jobs are getting fired.
Is there a way that I can get rid of these jobs?

Thanks
Vivek Mohan
XE update 3, Service Pack 18.1_B1
Windows NT Enterprise Server

Vivek,

just delete the jobs from your database. The table is svm7333.f986110.
If you can afford to lose all jobs in the table, just truncate it.

Or, start your JDENET services only, not JDEQUEUE. Log into your system
and delete all JOBS in 'W'.
Then start the q-services.

Good luck, Gerd

vivek,
you can run the R9861101 to clean up the F9861101 and the associated pdf
file on the enterprise server...


During the testing, we submitted a lot of jobs using scheduler(in
thousands). Now I want to delete all the jobs. So I ran the job R91300b to
perge the jobs. It perged the jobs from scheduler that are either completed
or launched.
But Now I see a lot of jobs in the Job Master(P986110B) with status=waiting
and as soon as I start the JDE services on the Enterprise server, these jobs
are getting fired.
Is there a way that I can get rid of these jobs?

Thanks
Vivek Mohan
XE update 3, Service Pack 18.1_B1
Windows NT Enterprise Serve

Vivek :

Run DELETE FROM SVM7333.F986110 WHERE JCJOBSTS='W' before starting
your JDE Services.

Sebastian

Try the UBE R91300A. This will call R91300B to delete the appropriate
jobs. You will have to specify your Server Map data source in the
processing options to run this version.

Adam Clark
Corporate Information Services
Office: (626) 434-4275





Adam Clark
Project Manager
Golden State Foods -- Information Services