1.定時任務(wù)的創(chuàng)建
declare
? x varchar2(20);
BEGIN
? DBMS_JOB.SUBMIT(
? ? ? JOB => x,? /*自動生成JOB_ID*/
? ? ? WHAT => 'DECLARE VAR_APPCODE VARCHAR2(200); VAR_ERRORMSG VARCHAR2(200);
? ? ? ? ? ? ? ? ? ? ? ? BEGIN
? ? ? ? ? ? ? ? ? ? ? ? ? PKG_DATASYNC.PRC_DATASYNC_CONTROL(VAR_APPCODE,VAR_ERRORMSG);
? ? ? ? ? ? ? ? ? ? ? ? ? ? END;',? /*需要執(zhí)行的存儲過程名稱或SQL語句*/
? ? ? NEXT_DATE => sysdate,? /*初次執(zhí)行時間-立即執(zhí)行*/
? ? ? INTERVAL => 'TRUNC(sysdate+ 1)+15/(48)' /*每隔1分鐘執(zhí)行一次*/
? );
? commit;
end;
備注：當(dāng)INTERVAL 參數(shù)傳入空值時，默認(rèn)執(zhí)行一次就完了筹误。
2.終止正在運(yùn)行的定時任務(wù)
begin
? dbms_job.broken(79,true);
? commit;
end;
3.刪除掉定時任務(wù)
begin
? dbms_job.remove(79); commit;
end;
4.修改定時任務(wù)的下次執(zhí)行時間
begin
? dbms_job.next_date(87,to_date('2021-08-30 03:00:02','yyyy-mm-dd hh24:mi:ss'));
? commit;
end;
5.查詢和刪除會話
select USERNAME, SID, SERIAL#, STATUS, osuser,MACHINE,PROGRAM,MODULE,ACTION,LOGON_TIME,SADDR,AUDSID,PADDR,USER#,COMMAND,OWNERID
from v$session
where username is not null
? and status = 'ACTIVE' and username='xxxxxxxx'
order by logon_time, sid;
alter system kill session '2720,15803' immediate;
6.sysdba用戶授權(quán)創(chuàng)建DBLINK
grant create DATABASE LINK to sc_510100;
7.創(chuàng)建DBLINK
create database dblinkNAME
connect to username? identified by password
using '(DESCRIPTION =(ADDRESS_LIST =(ADDRESS =(PROTOCOL = TCP)(HOST = 172.18.132.136)(PORT = 9000)))(CONNECT_DATA =(SERVICE_NAME = HMHN)))';
8.刪除dblink
drop database link dblinkname ;
9.查看DBlink
select * from dba_db_links;
