...and a quick test to list details about job number 1 would be :
bpdbjobs 1 -most_columns
bpdbjobs 1 -all_columns
...and you can collect most details for all jobs with :
bpdbjobs -most_columns -file myjobs-most.txt
...and all details for all jobs with :
bpdbjobs -all_columns -file myjobs-all.txt
The most_columns data should be quite easy to process.
The all_columns data contains two embedded expanding lists, and can prove to be quite tricky for scripting newbies to grasp. See this for some clues:
bpdbjobs gives a detailed output. I only want to see specific line or string like I only want to grep TFSDATABASEB.MSSQL7.TFSDB.db.TFS02_Warehousedata01
Like bpdbjobs -all_columns | find "TFSDATABASEB.MSSQL7.TFSDB.db.TFS02_Warehousedata01" is failed or PS command is also failed to grep
Ok the detail you need, i.e. that of resolved database names in SQL backup jobs, is revealed within only the -all_columns style output. As noted previously, this itself will be embedded within the try list, see the bpdbjobs documentation here:
...which at the very end says :
"Show the sample logic to decode -all_columns output to produce the backup initiation time of a job that succeeded, but not on the first try."