Job Commands

Copy

• Copy for LLM

  Copy page as Markdown for LLMs
• View as Markdown

  Open this page as Markdown
• Open in ChatGPT

  Get insights from ChatGPT
• Open in Claude

  Get insights from Claude
• Connect to Cursor

  Install MCP server on Cursor
• Connect to VS Code

  Install MCP server on VS Code

tdx jobs                              # List jobs
tdx job list                          # Same as jobs
tdx job schedule list                 # List scheduled queries

# List jobs (default: 40 jobs)
tdx jobs

# List more jobs
tdx jobs --limit 100

# Filter by status
tdx jobs --status running
tdx jobs --status success
tdx jobs --status error
tdx jobs --status queued

# Combine filters
tdx jobs --status running --limit 50

# Output as JSON
tdx jobs --json

# Show job details
tdx job show <job-id>

# Show as JSON
tdx job show <job-id> --json

# Submit Trino query (default)
tdx job submit "SELECT * FROM mydb.table LIMIT 10"

# Submit with specific database
tdx job submit "SELECT * FROM table" --database mydb

# Submit Hive query from file
tdx job submit --job-type hive -f query.sql --database mydb

# Submit without specifying database
tdx job submit "SELECT 1"

# Submit with result export destination (URL format)
tdx job submit "SELECT * FROM table" --database mydb --result "s3://bucket/path"

# Submit with result export destination (JSON format)
tdx job submit "SELECT * FROM table" --database mydb \
  --result '{"type":"s3_v2","td_authentication_id":12345,"bucket":"my-bucket","path":"/output/result.csv","format":"csv"}'

# Get job results (table format)
tdx job result <job-id>

# Get results as JSON
tdx job result <job-id> --json

# Save results to file
tdx job result <job-id> --output results.json

# Get results as TSV
tdx job result <job-id> --tsv

# Kill a job (with confirmation)
tdx job kill <job-id>

# Skip confirmation prompt
tdx job kill <job-id> --yes

# List all scheduled queries
tdx job schedule list

# Filter by wildcard pattern
tdx job schedule list "daily*"        # Starts with "daily"
tdx job schedule list "*_sync"        # Ends with "_sync"
tdx job schedule list "*hourly*"      # Contains "hourly"
tdx job schedule list "report_?"      # Single character wildcard

# Limit results
tdx job schedule list --limit 100

# Output as JSON
tdx job schedule list --json

# Show schedule details
tdx job schedule show <name>

# Show as JSON
tdx job schedule show <name> --json

# Create a scheduled query (minimal)
tdx job schedule create my-schedule \
  -d mydb \
  --file query.sql

# Create with cron expression
tdx job schedule create my-schedule \
  -d mydb \
  --file query.sql \
  --cron "0 0 * * *" \
  --timezone "America/Los_Angeles"

# Create with all options
tdx job schedule create my-schedule \
  -d mydb \
  --file query.sql \
  --type trino \
  --cron "0 0 * * *" \
  --timezone "America/Los_Angeles" \
  --delay 60 \
  --priority 1 \
  --retry-limit 3 \
  --engine-version stable \
  --result "td://mydb/result_table"

# Update cron expression
tdx job schedule update my-schedule --cron "0 12 * * *"

# Update query from file
tdx job schedule update my-schedule --file new-query.sql

# Update multiple options
tdx job schedule update my-schedule \
  -d newdb \
  --priority 2 \
  --retry-limit 5

# Delete a schedule (with confirmation)
tdx job schedule delete my-schedule

# Skip confirmation prompt
tdx job schedule delete my-schedule --yes

# Run immediately with current time
tdx job schedule run my-schedule

# Run with specific scheduled time
tdx job schedule run my-schedule --time "2025-01-15T00:00:00Z"

# Run multiple times (1-10)
tdx job schedule run my-schedule --num 3

# Show execution history (default: last 20)
tdx job schedule history my-schedule

# Show with pagination
tdx job schedule history my-schedule --from 0 --to 50

# Output as JSON
tdx job schedule history my-schedule --json