cancel
Showing results for 
Search instead for 
Did you mean: 

bpdbjobs wanted to sort by jobid by ascending order

gbkhor
Level 2

Hello

I'm running 7.6.1 on win2008 R2 SP1

By default when you execute bpdbjobs.exe - report -file c:\file.csv

the output is automatically sorted the job id in descending order, is there a way to sort it in ascending order by jobid?

Thanks a lot

1 ACCEPTED SOLUTION

Accepted Solutions

Mark_Solutions
Level 6
Partner Accredited Certified

I dont believe this is possible - it just pipes out the information from the jobs database as it reads it - so will always be in job order

You would need to write a small script to reverse it once piped out

View solution in original post

4 REPLIES 4

Mark_Solutions
Level 6
Partner Accredited Certified

I dont believe this is possible - it just pipes out the information from the jobs database as it reads it - so will always be in job order

You would need to write a small script to reverse it once piped out

SymTerry
Level 6
Employee Accredited

Connect user Satkay worked on a VB script last year that took the bpdbjobs -all_columns and generated reporting. This may help as well.

Since this is something that is user generated, you would want to take caution on its use and post on that thread for configuration and support. 

gbkhor
Level 2

Thanks Mark and Terry

Mark_Solutions
Level 6
Partner Accredited Certified

Dont forget once you are sorted out to close off the thread using the Mark as solution or Request split solution - helps others in the future and stops it turning up in the "can you solve these" column!