NB 6.0 remove code 150 from bpdbjobs reporting 1

[CalgaryCR9]

We are running NB 6.0 MP4. Our nightly reporting is based on bpdpjobs output. I'd like to cron a job to remove the error code 150 output from the db prior to kicking off our nightly report.

What is the command to remove error code 150 from the db?

 

[Stumpr]

You can't remove specific entries from the db.
however, you can remove them from the activity monitor.

Bob Stump
VERITAS - "Ain't it the truth?"

 

[CalgaryCR9]

I thought the previous versions of NB allowed this. I'll tweak my script to omit entries with a status code 150.

Thanks.

 

[CalgaryCR9]

A colleague recommended the following:

bpdbjobs -report -most_columns | \
nawk -F"," '{if ($4==150) print"bpdbjobs -delete "$1}'\
> /tmp/kill_jobs; sh /tmp/kill_jobs


WORKS LIKE A CHARM!