Are you submitting the job as the perfstat user?
Tim
-Original Message-
Sent: Wednesday, December 19, 2001 12:26 PM
To: Multiple recipients of list ORACLE-L
> "Daiminger, Helmut" wrote:
>
> Hi!
>
> I created a new job in a database:
>
> variable jobno number;
> begin
> dbms_job.subm
> "Daiminger, Helmut" wrote:
>
> Hi!
>
> I created a new job in a database:
>
> variable jobno number;
> begin
> dbms_job.submit (:jobno, 'statspack.snap;', sysdate, 'trunc
> (sysdate,''HH24'') + trunc ((sysdate - trunc (sysdate,
> ''HH24''))*96+1)/96');
>
> commit;
> end;
>
> The job was suc