Обсуждение: Cleaning job statistics

Sabin Coanda wrote:
> Hi,
>  
> I'd like to clean my statistics list of a job step.
> Do you know how, please ?
>

If I remember correctly, something like:

DELETE FROM pgagent.pga_jobsteplog WHERE jsljstid = <job step ID>;

Regards, Dave

> Sabin Coanda wrote:
>> Hi,
>>  I'd like to clean my statistics list of a job step.
>> Do you know how, please ?
>>
>
> If I remember correctly, something like:
>
> DELETE FROM pgagent.pga_jobsteplog WHERE jsljstid = <job step ID>;
>
> Regards, Dave

Hi Dave,

Thank you for help.
Would you like to provide some documentation with pgagent database objects, 
please ?

Regards,
Sabin