Pinned Loading

1. WRKODBCJOB in SQL WRKODBCJOB in SQL

   1

   -- Bryan Dietz

   2

   -- trying to get some results similar to WRKODBCJOB

   3

   4

   SELECT Aj.Subsystem

   5

          ,Aj.Job_Name

2. Show_PTFs_on_system Show_PTFs_on_system Public

   from the all PTFs CSV file show which are loaded/appied on your server

3. Work with Remote Writers Work with Remote Writers

   1

   -- category: bryan.dietz

   2

   -- description: WRKRMTWTR  

   3

   -- Inspired by : http://bryandietz.us/wrkrmtwtr.html

   4

   SELECT TRIM(Output_Queue_Library_Name) CONCAT '/' CONCAT TRIM(Output_Queue_Name) AS Output_Queue

   5

          ,Number_Of_Files AS "# Splf"

4. Telnet jobs (showip) Telnet jobs (showip)

   1

   --  description: netstat - jobs from telnet sessions Regular and SSL

   2

   SELECT 

   3

    Remote_Address 

   4

   ,LOCAL_ADDRESS

   5

    , Job_Name