Product

Platform

Intel

Operating system

Windows NT/Windows 2000 Server

Error

Symptoms

Cause

Solution

WARNING: This script is to be used only by CreoScitex personnel for Prinergy 1.1; it is not to be distributed to the customer. For Prinergy 2.0.7, there is a database report that list who create\destroy job.

1. Create a job called "FindDestroyedJobs" onto the Prinergy Server D: drive, e.g. \\%Prinergyhome%\CreoAraxi\Support\Bin folder.

2. Download the FindDestroyedJobs.zip file from the Related Links section to the folder and then extract it. It contains two files, FindDestroyedJobs.bat and FindDestroyedJobs.sql.

3. RCMD into the system.

4. Open a DOS prompt, type "FindDestroyedJobs" and enter. This will start the script:

5. Following the prompt, enter the job name (the queries are case sensitive so you have to find the true job name).

6) Enter the user name or partial user name, and press enter for all users.

The result will show the jobname, user, and date destroyed columns.

For e.g.

D:\>/* 2>NUL

*******************************

Find Destroyed Jobs in Prinergy

*******************************

This script will display a list of Prinergy jobs that were destroyed.

NOTE: The job names and user names are case-sensitive.

Enter the job name or partial job name (press <RETURN> for all jobs):

Enter the user name or partial user name (press <RETURN> for all users):

old 4: AND histlogparam1 LIKE '%&job%'

new 4: AND histlogparam1 LIKE '%%'

old 5: AND username LIKE '%&user%'

new 5: AND username LIKE '%%'

Jobname User Date Destroyed

----------------------------------- ------------------------------ --------------------

AmyTest Araxi Aug 28 2000 12:01:50

NewITP AChan Sep 07 2000 16:57:13

New Mexico araxi Sep 14 2000 17:15:15

Permanent fix: Prinergy 2.0

See also

FindDestroyedJobs.zip

Keywords

archiver FAQs

Technical contact(s)

Amy Chan

Submitted by

Amy Chan

Date submitted