<?php
$URL="https://raw.githubusercontent.com/panticz/installit/master/install.squirrel-sql.sh";
echo "wget $URL -O - | bash -";
echo "
"; $c = curl_init(); curl_setopt($c, CURLOPT_URL, $URL); curl_setopt($c, CURLOPT_RETURNTRANSFER, 1); echo htmlspecialchars(curl_exec($c)); curl_close($c); echo "
";
?>
view jobs
select *
from user_scheduler_jobs
create job
BEGIN
DBMS_SCHEDULER.CREATE_JOB (
job_name => 'YOUR_JOB_NAME',
job_type => 'stored_procedure',
job_action => 'testproc',
start_date => TRUNC(SYSDATE),
repeat_interval => 'freq=DAILY;byhour=5',
-- repeat_interval => 'freq=hourly;byminute=5',
-- repeat_interval => 'freq=DAILY; BYDAY=MON,TUE,WED,THU,FRI; BYHOUR=7,15',
enabled => TRUE
);
END;
delete job
exec dbms_scheduler.drop_job('YOUR_JOB_NAME')
DB Clients
http://www.squirrelsql.org - SQuirreL SQL, universal SQL Client, supports MS SQL and other DB
Connect from OpenOffice / LibreOffice to MsSQL Server
http://www.oooforum.org/forum/viewtopic.phtml?t=24036
Links
https://flywaydb.org/getstarted/ - database migrations