Need to Seed starting value return by Job_Run_id function

dataservices administration
1

Hi all,

we are in the process of migrating to a fresh install of Data Services 4.2 ( new hardware) and are moving from Oracle to MSSQL for our repo.

We have our own framework that captures audit information for the Job runs. Part of what we grab is the Job_Run_ID.

What I am needing is the ability to “Seed” the initial value that is used to generate the Job_Run_ID so that when we write to our audit records we do not get duplicate ID values .

Does anyone know where the Job_Run_ID looks to get the value or a way to seed the value :?: :?:

Thanks in advance,

Jon Roberts

DS 4.2 SP6
BOBJ 4.1 sp4 / BOBJ 4.2 sp2
Windows 2012

JonnySpec :us: (BOB member since 2008-08-01)

2

It looks like the Job IDs (in ALVW_JOBINFO) come from the AL_LANG table, which uses the AL_LANG_SEQ to increment.

thesnow :us: (BOB member since 2011-08-10)

3

Snow,

Thank you for the response.

Job_ID is a different piece of data. What we are needing is the ability to seed(set the starting number) returned by the Job_Run_ID() function. trying to figure out where that function looks to get the next value in sequence.

Very frustrating that this is not documented anywhere… Not like we are the first to move to new hardware and re-setup the repositories.

JonnySpec :us: (BOB member since 2008-08-01)

4

Sorry, missed that the first time around. Try the AL_HISTORY_SEQ instead.

thesnow :us: (BOB member since 2011-08-10)

5

the the value returned by the job_run_id() is th object_key value from the AL_HISTORY table, every time a job run the max(object_key) + 1 is returned as new object_key

you should use your own control table to track the histroy of job runs, if all the history is deleted ,the value will start from 1

manoj_d (BOB member since 2009-01-02)