UBE processing BSFN

[jgersic93]

Hopefully someone knows this one, as I have not found a bsfn that does it
(yet). What I need is to be able to pull the name of the .pdf that is being
created by a currently processing ube. I am creating a work table that
populates it with some information which would be the key, and then the name
of the .pdf that is being created... Is there such a function that you can
call from within a UBE and it returns the name of the .pdf it is creating?

Thanks,
John
----------------------------------------------------------
OneWorld Xe (B733.3)
Update 2, SP 16
Oneoffs: SP16_011, _018, _019
Running on: WIN2K/SP2, SQL2k/SP2
Metaframe 1.8a
----------------------------------------------------------


-----------------------------------------------------------------------
John Gersic
Financial Systems DBA
PH: 703.744-6057
1861 International Drive
McLean, Virginia 22102
Microstrategy - Best in Business Intelligence
http://www.microstrategy.com/ <http://www.microstrategy.com/>
-----------------------------------------------------------------------

 

[scotto72]

I'm on SQL 7.0, but here's a suggestion -

If you are only interested in populating a temp table or somesuch, you can put a trigger on the F986110. The filename is contained in the JCFNDFUF2 column. I have one that runs to track the # of jobs in the queue and to track how long the UBE's wait and how long they run (For performance reasons.) You could either do it in TER, or at the database level. Once the job is submitted it INSERTs the record and that includes the filename (Which consists of <UBENAME>_<VERSION>_<JOB #>_PDF - you have to manually append the .pdf if you want the true filename). My testing indicates that the INSERT trigger does not negatively affect performance too greatly. Also, if you can get the JOB# somehow, you can manually create the filename yourself. If you want an example, let me know....

- Scotto