I am not asking for fast response here but just wondering if I explained my question properly...Does anyone else have the issue or is it just on my side ?
Your question is fine, it's just that I for one have no idea what the answer might be. I thought the name of the job was only in the DSJOB table as the NAME field, I'm not familiar with the gory details of the JOBRUN and JOBEXEC tables. If your filter is working it must be present there in some fashion, however.
Hopefully one of the Universe experts like Ray or Kim will know the why of it...
-craig
"You can never have too many knives" -- Logan Nine Fingers
Found the issue...'Job Name' column is defined as vargraphic data type so the query tool I was using was not able to display it. I converted to char and it works now...