oracle数据库管理员创建用户的job
begin
dbms_ijob.submit(JOB编号,'用户','用户','用户',
to_date('30-08-2012 02:00:00', 'dd-mm-yyyy hh24:mi:ss'),
'to_date(to_char(sysdate+1,''yyyymmdd'')||'' 02:00:00'',''yyyymmdd hh24:mi:ss'')',
false,'存储过程名称;',
'NLS_LANGUAGE=''SIMPLIFIED CHINESE'' NLS_TERRITORY=''CHINA'' NLS_CURRENCY=''￥'' NLS_ISO_CURRENCY=''CHINA'' NLS_NUMERIC_CHARACTERS=''.,'' NLS_DATE_FORMAT=''DD-MON-RR'' NLS_DATE_LANGUAGE=''SIMPLIFIED CHINESE'' NLS_SORT=''BINARY''',
'0102000200000000');
commit;
end;
dbms_ijob.submit(JOB编号,'用户','用户','用户',
to_date('30-08-2012 02:00:00', 'dd-mm-yyyy hh24:mi:ss'),
'to_date(to_char(sysdate+1,''yyyymmdd'')||'' 02:00:00'',''yyyymmdd hh24:mi:ss'')',
false,'存储过程名称;',
'NLS_LANGUAGE=''SIMPLIFIED CHINESE'' NLS_TERRITORY=''CHINA'' NLS_CURRENCY=''￥'' NLS_ISO_CURRENCY=''CHINA'' NLS_NUMERIC_CHARACTERS=''.,'' NLS_DATE_FORMAT=''DD-MON-RR'' NLS_DATE_LANGUAGE=''SIMPLIFIED CHINESE'' NLS_SORT=''BINARY''',
'0102000200000000');
commit;
end;
如上，替换一下里面的中文描述即可。
