For Oracle's regular job I'm not very understanding, encounter a problem recently, before others write regular job now seems to have not perform, then I took half a day did not find problem, therefore came to consult everybody,
Explain, this stored procedure involved will be excluded from the view of a data source dblink data is added to another table, don't know if timing task does not perform is associated with this,
Trouble you know help me find problem, thanks!

CodePudding user response:

You alone performed manually, and see if it is an error, error of 16 times in a row, the JOB will be automatically broken is not carried out

CodePudding user response:

reference 1st floor sxq129601 response:

you separately performed manually, and see if it is an error, error of 16 times in a row, the JOB will be automatically broken does not perform the

Should be performed successfully, you have a look at the screenshot

CodePudding user response:

Should be carried out, and let them check the logic;

CodePudding user response:

reference wmxcn2000 reply: 3/f

should be carried out, let them check the logic;

Logic should also do not have what problem, below is the timing of tasks to perform storage is in your bag (),
Left left left left left left left left left left down down down down down down down down down left left left left left left left left left left down down down down down down down down down left left left left left left left left down down down down down down down left left left left left left left left left down down down down down down down down left left left left left left left left left left down down down down down down down down down left left left left left left left left left left down down down down down down down down down left left left left left left left left left left down down down down down down down down down
The create or replace package body UP_SOA_GET is
G_mess varchar2 (1000);

- timing task
Procedure p_clgl_job is
/* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
* description: timing task synchronization state a vehicle running kilometers
* parameter
* data source: soa eight fonda system lead library begins at 8 o 'clock pushed to the front within five minutes, library
* object library: eight fonda system local library
* steps: 1, simultaneous date
* 2, synchronous data
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * */
Ret_out integer;
V_riqi varchar2 (20);
The begin
V_riqi:=to_char (sysdate - 1, 'mm - dd yyyy -');
P_clgl (v_riqi ret_out);
The end;

- synchronous data traffic km from soa synchronous 160203
Procedure p_clgl (in_riqi in varchar2, ret_out out integer) is
/* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
* description: synchronous data traffic km from soa synchronous 160203
* parameter
* in_riqi varchar2 date - dd yyyy - mm in
* iret_out out integer return 1 success - 1 failure
* the target table: T_SOA_CLGLB
* the original table: v_soa_clglb
* steps: 1, delete data
* 2, insert the data
Update company's id
* 3,* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * */
V_date date;
The begin
Ret_out:=1;
V_date:=to_date (in_riqi, 'mm - dd yyyy -');

G_mess:='delete specified date data:' | | in_riqi;
The delete from T_SOA_CLGLB where SJRQ=v_date;

G_mess:='insert date specified data:' | | in_riqi;
Insert into T_SOA_CLGLB
(CKCZLCID SJRQ, CKCLID CLZBH, CKJGID, YYLC, FYYLC, YXGL)
The select ckczlcid SJRQ, ckclid CLZBH, ckjgid, yylc, fyylc, YXGL
The from v_soa_clglb
Where SJRQ=v_date;

G_mess:='update company id:' | | in_riqi;
The update T_SOA_CLGLB t
The set gsid=(select company_id
The from t_core_vehicle v
Where v.v eh_code=tc LZBH
And V.v eh_isdelete='F')
Where SJRQ=v_date;
commit;

The exception
The when others then
The rollback.
Ret_out:=1;
G_mess:=g_mess | | ', '| | sqlerrm;
P_SAVE_MESSAGE (g_mess, UP_MT_CONSTANT C_PROC_NO, 'p_clgl,
UP_MT_CONSTANT. C_MT_MAIN);
commit;
The end;

End UP_SOA_GET;
Write write write write write write write write write write write write write write write write write write write write write write write write write write write write write write write write write write write write write write write write write write write write write write write write write write write write write write write write write write write write write write write write write write write write write write write write write write write write write write write write write write write write write write write write write write write write write

Do you see there is a problem?
V_soa_clglb this view, which is what I said the dblink data source

CodePudding user response:

P_SAVE_MESSAGE this is used to record log?

Part of the success, also the record log, and see whether carried out;

CodePudding user response:

reference 5 floor wmxcn2000 reply:

P_SAVE_MESSAGE this is used to record the log?

Part of the success, also the record log, and see whether carried out;

Er, I add a trigger to T_SOA_CLGLB, just delete, add or modify to the a log list will add a log, but when timing task execution, the log table without logging information, the three operation is a all have no,

CodePudding user response:

What's the matter?

CodePudding user response:

how to do???????

CodePudding user response:

You see you performed manually, do we have to add data, if there is no problem is process, if there are data add is your job, make sure which problem

CodePudding user response:

references 9 f sxq129601 response:

you performed manually, to see if you have any add data, if no problem is process, if there are data add is your job, make sure which problem

Manual is ok, that is the job, but job what problem

CodePudding user response:

references to the tenth floor baidu_35093115 response:

Quote: references 9 f sxq129601 response:

You see you performed manually, do we have to add data, if there is no problem is process, if there are data add is your job, make sure which problem

Manual is ok, that is the job problem, but what problem does the job

references to the tenth floor baidu_35093115 response:

Quote: references 9 f sxq129601 response:

You see you performed manually, do we have to add data, if there is no problem is process, if there are data add is your job, make sure which problem

Manual is ok, that is the job problem, but what problem does the job

See the select value from v $parameter where the name like '% job_queue_processes %', how much is the value of the

CodePudding user response:

I had a execution is 10

CodePudding user response:

See the select value from v $parameter where the name like '% job_queue_processes %', how much is the value of the

I carried out once, is 10nullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnull