SQL & PL/SQL

Hi All,

I have one procedure and i need to schedule that procedure to run daily at 10 Pm.

I have created a Job scheduler but i got error that identifier must be declare,

This is my code

begin
dbms_scheduler.create_job(
job_name => Test_schedule,
job_type =>'PL/SQL_BLOCK',
job_action =>'begin TEST_CLIENT_AGREEMENT; end;',
start_date =>SYSTIMESTAMP,
repeat_interval =>'freq=daily; byhour=0; byminute=0; bysecond=0;',
END_DATE => NULL,
ENABLED => TRUE,
COMMENTS => 'Refreshes Materialized Views on a Scheduled Basis (10:00 PM each day).');
END;

How to declare the job name.Whether i need to create a procedure and i need to pass any variable.



Thanks & Regards
Srikkanth.M