hi

lets' track ur errors. I refer to ur code only.

1- U r defining a SQL*PLUS bind variable, when u use

Variable jobno number;

take out the declare ( here u start a PL/SQL !).

2. U havn't put a ';' (semi colon) with 'test.add_data'

it should be 'test.add_data;'

line wise i will code the thing.
your code should be like this

1.variable jobno number;

2.begin

3.dbms_job.submit(:jobno,'test.add_data;',sysdate,'sysdate+1/288');

4.commit;

5. end;


the need of commit ----
to commit the job submission as a transaction, u should issue the COMMIT, just after the dbms_job.submit(.......);

hope this will clear ur problem.

Valsaraj