Jitterbit PostgreSQL Info

Jitterbit PostgreSQL Info.sh

# Connect to PostgreSQL from Linux
/opt/jitterbit/pgsql/bin/psql -d postgres -U jitterbit -p 46914

# List databases
\l

# list tables
\dt

# Connect to TranDb database
\c TranDb

# Check Schedules
SELECT * FROM schedulestab;

# Check operations running specific schedule (use schedule_id column value from above results).
SELECT * FROM operationstab WHERE schedule_id=350822;

# Check for leftover operations waiting to run
SELECT * FROM incomingmsgtab;

# Clear out operations waitign to process
TRUNCATE table incomingmsgtab;