oralce job:
ALTER SYSTEM SET JOB_QUEUE_PROCESSES=39 SCOPE=SPFILE;
ALTER SYSTEM SET JOB_QUEUE_PROCESSES = 10;
create table a(a date);
create or replace procedure test as
begin
insert into a values (sysdate);
end;
/
variable job1 number;
begin
dbms_job.submit(:job1,'test;',sysdate,'sysdate+1/1440');
--每天1440分钟,即一分钟运行test过程一次
end;
/
begin
dbms_job.run(:job1);--调用
end;
/
begin
dbms_job.remove(:job1); --移除
end;
/
Mysql Event Scheduler:
USE test;
CREATE TABLE aaa (timeline TIMESTAMP);
--创建事件
CREATE EVENT e_test_insert
ON SCHEDULE EVERY 1 SECOND
DO INSERT INTO test.aaa VALUES (CURRENT_TIMESTAMP);
ALTER EVENT e_test ENABLE; --开启事件
DROP EVENT IF EXISTS e_test; --删除事件
mssql2005 job:
USE Master
GO
declare @str varchar(100) --完整备份,每周一次
set @str='D:\DBtext\jgj\DBABak\FullBak'+replace(replace(replace(convert(varchar,getdate(),20),'-',''),' ',''),':','')+'.bak'
BACKUP DATABASE [demo] TO DISK=@str
WITH RETAINDAYS=15,NOFORMAT,NOINIT,
NAME=N'Demo完整备份',SKIP,NOREWIND,
NOUNLOAD,STATS=10
GO
网络收集