BCA Action Codes

I have a listing of the jobs that are on my BCA server. In the actions column it says something like this:

1,4[Report Name!Macro Name]
1,8
1,9[\UNC Path]
1,8[\UNC Path],4[Report name!Macro Name]

I think I can tell what codes 1, 4 and 8 are by the information presented. It looks like 1 is Refresh, 4 is custom macro, and 8 is save as text.

Is there a list somewhere that gives codes 1 - 9 and their description?

I searched here an BO and didn’t see it, but maybe I’m not calling them the right thing?

Thanks!

Mary


Juddy5 :us: (BOB member since 2002-11-22)

Hi,

what is your BCA version.

My version is 5.1.8 and I haven’t any code near, the job description.


nicolasD :fr: (BOB member since 2004-07-22)

This is the decode that we use in our Universe:

rtrim(decode(sign(instr(DS_PENDING_JOB.JOB_SCRIPT, ‘1’)), 1, 'Refresh, ', null) ||
decode(sign(instr(DS_PENDING_JOB.JOB_SCRIPT, ‘2,’)), 1, 'Print (default printer), ', null) ||
decode(sign(instr(DS_PENDING_JOB.JOB_SCRIPT, ‘2[’)), 1, 'Print , ', null) ||
decode(sign(instr(DS_PENDING_JOB.JOB_SCRIPT, ‘3,’)), 1, 'Webserver, ', null) ||
decode(sign(instr(DS_PENDING_JOB.JOB_SCRIPT, ‘4[’)), 1, 'Webserver using custom macro, ', null) ||
decode(sign(instr(DS_PENDING_JOB.JOB_SCRIPT, ‘5,’)), 1, 'Condition, ', null) ||
decode(sign(instr(DS_PENDING_JOB.JOB_SCRIPT, ‘6,’)), 1, 'Channel, ', null) ||
decode(sign(instr(DS_PENDING_JOB.JOB_SCRIPT, ‘7[’)), 1, 'Save as RTF, ', null) ||
decode(sign(instr(DS_PENDING_JOB.JOB_SCRIPT, ‘7,’)), 1, 'Save as RTF, ', null) ||
decode(sign(instr(DS_PENDING_JOB.JOB_SCRIPT, ‘8[’)), 1, 'Save as text, ', null) ||
decode(sign(instr(DS_PENDING_JOB.JOB_SCRIPT, ‘8,’)), 1, 'Save as text, ', null) ||
decode(sign(instr(DS_PENDING_JOB.JOB_SCRIPT, ‘9[’)), 1, 'Save as PDF, ', null) ||
decode(sign(instr(DS_PENDING_JOB.JOB_SCRIPT, ‘9,’)), 1, 'Save as PDF, ', null), ', ')

I didn’t write it, so can’t guarantee that it’s correct; but it should point you in the right direction.[/code]


anorak :uk: (BOB member since 2002-09-13)

Thanks!

This looks like what I had partially deduced from looking at our existing jobs, and explains the ones we don’t happen to be using.

It also makes it a bit clearer on why sometimes I see an 8 followed by nothing, and an 8 followed by a [path]. It’s the difference between using the default temp directory and specifying a path for things that are being exported or saved.

Mary


Juddy5 :us: (BOB member since 2002-11-22)