Callable Procedures > Call Syntax
  
Call Syntax
The calling syntax is:
SQL Server: Exec Ws_Job_Clear_Logs @v_sequence, @v_job_name, @v_task_name, @v_job_key, @v_task_key, @v_job_to_clean, @v_keep_count, @v_return_code OUTPUT, @v_return_msg OUTPUT, @v_result OUTPUT
Oracle: v_result := Ws_Job_Clear_Logs(v_sequence, v_job_name, v_task_name, v_job_key, v_task_key, v_job_to_clean, v_keep_count, v_return_code, v_return_msg);
DB2: CALL [METABASE].Ws_Job_Clear_Logs(v_sequence, v_job_name, v_task_name, v_job_key, v_task_key, v_job_to_clean, v_keep_count, v_return_code, v_return_msg, v_result);
Parameters
The following parameters are required:
Note: In the event of an unexpected failure an entry is inserted in the audit log. The Sequence, Job Name and Task Name are added as part of this entry along with the error message.
 
Parameter
Description
Sequence
See Common Parameters (on page 813)
Job Name
See Common Parameters (on page 813)
Task Name
See Common Parameters (on page 813)
Job Key
See Common Parameters (on page 813)
Task Key
See Common Parameters (on page 813)
Job to clean
The name of the job that is to have logs removed. This can be the name of the current job if required.
Keep count
The number of logs to keep. The oldest logs will be removed leaving the latest (keep count) logs.
Return code
This code indicates the result of the call. See the table below for the return codes.
Return message
A message indicating the action taken, or the reason for no action.