1. Job execute the stored procedure, the stored procedure no problem, have determined that
2. If I set executed cycles per minute, sysdate + 1/1440. Also no problem;
But if I set to a designated to perform every day, every night 23 points, for example, trunc (sysdate + 1) + 23/24. Have failed, in user_job failures field has been accumulative failure times,
Declare job1 is number;
The begin
Sys. Dbms_job. Submit (
Job1 is,
'hi_test; '
To_date (' 2014-12-25:23:00:00 ', '- DD YYYY - MM: HH24: MI: SS'),
'trunc (sysdate + 1) + (23 * 60)/(60 * 24)' - 23 points to perform every day
);
Commit;
end;
/

CodePudding user response:

What is the probable cause? For help

CodePudding user response:

Looked at do not have what problem!
You carry out hi_test independently, and see if it is the process itself has a problem

CodePudding user response:

refer to the second floor bw555 response:

looked at do not have what problem!
You carry out hi_test independently, and see if it is the process itself has a problem.

Stored procedure is absolutely no problem, which is confirmed,
And I'm the first in the development of the local environment is also good, this job everyday normal execution,
Later on replication in test environment, I always failed after a few days to see,,, strange, and I put this script in the local development environment tried, if change every minute in the execution is no problem, if it is a day's execution time is fail,,,

CodePudding user response:

Should be stored procedure code related with you, with increasing of time span and data
The difference of data is likely to lead to the failure of the stored procedure, single track, the concrete is the issue of the statement

CodePudding user response:

The

reference 4 floor bw555 reply:

should be stored procedure code related with you, with increasing of time span and data
Data difference is likely to lead to the failure of the stored procedure, the single track, look at the specific statement that is

In order to verify whether the stored procedure problem, I just output in a word, only in a stored procedure, and single tracking is how to operate,

CodePudding user response:

Stephen SDFDSF

CodePudding user response:

Look at the alert log the error information is what

CodePudding user response:

Test environment, the process involved in the list, methods such as object ever give permission

CodePudding user response:

To solve, I also appears the question, time has been accumulated, interval is not an error

CodePudding user response:

This has nothing to do with the Job, is to run storage problems in the process,
You can test on your own, and see where the problem of the positioning,

Also encountered this problem before,

CodePudding user response:

To solve, I also encountered such a problem now, timing, the job has been failed, failed a few times and succeeded, manually execute a stored procedure, there is no error,