(19c)
https://oracle.programmer-reference.com/dbms-scheduler-create-job/
BEGIN
DBMS_SCHEDULER.CREATE_JOB (
job_name => 'JOB1',
job_type => 'STORED_PROCEDURE',
job_action => 'TEST.PROC1',
number_of_arguments => 1,
start_date => TO_DATE('2001/01/01 00:00:00','YYYY/MM/DD HH24:MI:SS'),
repeat_interval => 'FREQ=DAILY;INTERVAL=1',
end_date => TO_DATE('2030/12/31 23:59:59','YYYY/MM/DD HH24:MI:SS'),
auto_drop => FALSE,
comments => 'JOB1');
END;
/
show events\G
show create event proc1;
CREATE EVENT proc1
ON SCHEDULE EVERY 1 DAY STARTS '2017-01-01 00:00:00'
DO
call proc1();
vim /etc/my.cnf
event_scheduler = ON
--pgAdmin4のインストール
参考URL : https://qiita.com/silverskyvicto/items/672a5cb98287188348fe
yum -y install epel-release
yum -y install pgadmin4
mkdir /var/www/pgadmin4 /var/log/pgadmin4
chown -R apache:apache /var/www/pgadmin4 && find /var/www/pgadmin4 ! -user apache | wc -l
cp -a /etc/httpd/conf.d/pgadmin4.conf.sample /etc/httpd/conf.d/pgadmin4.conf && vi /etc/httpd/conf.d/pgadmin4.conf
#LoadModule wsgi_module modules/mod_wsgi.so ←コメントアウト
WSGIDaemonProcess pgadmin processes=1 threads=25
WSGIScriptAlias /pgadmin4 /usr/lib/python2.7/site-packages/pgadmin4-web/pgAdmin4.wsgi
<Directory /usr/lib/python2.7/site-packages/pgadmin4-web/>
WSGIProcessGroup pgadmin
WSGIApplicationGroup %{GLOBAL}
<IfModule mod_authz_core.c>
# Apache 2.4
Require all granted
</IfModule>
<IfModule !mod_authz_core.c>
# Apache 2.2
Order Deny,Allow
Deny from All
Allow from 127.0.0.1
Allow from ::1
</IfModule>
</Directory>
vi /usr/lib/python2.7/site-packages/pgadmin4-web/config_local.py
SERVER_MODE = True
DEFAULT_SERVER = '192.168.137.50'
LOG_FILE = '/var/log/pgadmin4/pgadmin4.log'
SQLITE_PATH = '/var/www/pgadmin4/pgadmin4.db'
SESSION_DB_PATH = '/var/www/pgadmin4/sessions'
STORAGE_DIR = '/var/www/pgadmin4/storage'
python /usr/lib/python2.7/site-packages/pgadmin4-web/setup.py
python /usr/lib/python2.7/site-packages/pgadmin4-web/pgAdmin4.py &
http://192.168.137.50:5050/browser/
--pgAgentのインストール
参考URL : https://www.pgadmin.org/docs/pgadmin4/dev/pgagent.html
yum -y install pgagent_94
CREATE EXTENSION pgagent;
参考URL : https://docs.microsoft.com/ja-jp/sql/ssms/agent/create-a-job?view=sql-server-2017
USE msdb ;
GO
EXEC dbo.sp_add_job
@job_name = N'Weekly Sales Data Backup' ;
GO
EXEC sp_add_jobstep
@job_name = N'Weekly Sales Data Backup',
@step_name = N'Set database to read only',
@subsystem = N'TSQL',
@command = N'ALTER DATABASE SALES SET READ_ONLY',
@retry_attempts = 5,
@retry_interval = 5 ;
GO
EXEC dbo.sp_add_schedule
@schedule_name = N'RunOnce',
@freq_type = 1,
@active_start_time = 233000 ;
USE msdb ;
GO
EXEC sp_attach_schedule
@job_name = N'Weekly Sales Data Backup',
@schedule_name = N'RunOnce';
GO
EXEC dbo.sp_add_jobserver
@job_name = N'Weekly Sales Data Backup';
GO
