oracle-dba-job-scheduling-automationlisted

USE THIS SKILL WHENEVER the user mentions DBMS_SCHEDULER, the Oracle Scheduler, scheduler jobs / programs / schedules / job classes / windows, job CHAINS, external (OS-executable) jobs, scheduler CREDENTIALS, calendaring repeat_interval strings, cron jobs or Windows Task Scheduler that drive Oracle work, BROKEN / FAILED / stuck scheduler jobs, rescheduling a job, "run a job now" / STOP_JOB / RUN_JOB, job-log retention/purge, or migrating a legacy DBMS_JOB — EVEN IF they do not name the specific task. Covers scheduler + OS-cron job MONITORING (T1), DBMS_SCHEDULER and external job CREATION, RESCHEDULING, job-chain configuration, and job-failure diagnose+remediate (T2, dry-run default), plus the plan-only Tier-3 runbooks for drops / forced runs / complex chains / credential creation / log purge / DBMS_JOB migration. Follows the oracle-dba-common contracts: SQLcl MCP saved connection dba_ai_conn, Oracle Wallet secrets (never plaintext, never SYS/SYSTEM by default), --dry-run defaults on T2, and tier gating (max s
Shreyas70773/oracle-dba-agentic-skills · ★ 0 · AI & Automation · score 62

Install: claude install-skill Shreyas70773/oracle-dba-agentic-skills

# Oracle DBA - Job Scheduling & Automation In-DB job orchestration (DBMS_SCHEDULER jobs, programs, chains, external/OS jobs, credentials) and the host OS schedulers (cron / Windows Task Scheduler) that drive the wrapper scripts, for Oracle 19c and 23ai (EE; single_instance and Data Guard; on-prem). Everything self-executing is **T1 (observe)** or **T2 (reversible, dry-run-default)**. Every **drop / forced run / complex-chain design / credential creation / log purge / DBMS_JOB migration is T3** and lives only in `references/runbooks.md` — it prints commands for a human and never self-executes. ## Scope & risk map | Task | Level | Tier | Mechanism (script / sql / runbook path) | Idempotent? | |------|-------|------|------------------------------------------|-------------| | Scheduler job monitoring | L1 | T1 | `scripts/checks/check_scheduler_jobs.sh` / `.ps1` + `sql/scheduler_job_status.sql` | yes — read-only (emits KEYVAL metrics + threshold findings, never mutates) | | Cron / OS scheduled-job monitoring | L1 | T1 | `scripts/checks/check_cron_jobs.sh` / `.ps1` | yes — read-only; scans host scheduler + oracle-dba logs; no DB needed | | Job rescheduling (change repeat_interval) | L1 | T2 | `scripts/reschedule_job.sh` / `.ps1` + `sql/reschedule_job.sql` | yes — noop when interval already equals target (`state=already_set`); logs OLD interval for rollback | | DBMS_SCHEDULER job creation (PL/SQL block) | L2 | T2 | `scripts/create_scheduler_job.sh` / `.ps1` + `sql/create_schedule