Remove Job Scheduler (JSH) records using Interactive SQL (SQLEngine)

The following procedure details how to remove job scheduler (jsh) records using Interactive SQL.

To remove jsh records using Microsoft SQL

1. Open an Interactive SQL (ODBC) console, and then connect to the RealTime database (RTDB) in the system (connect <system>rtdb) or use DALSQLTestClient to connect to the system.

2. Execute the following commands:

   delete from jsh where name = 'archive';

   delete from jsh where name = 'cleanupTimeSeriesCollect';

   delete from jsh where name = 'cleanupTimeSeriesHour';

   delete from jsh where name = 'cleanup';

   delete from jsh where name = 'summary';

   delete from jsh where name = 'TimeSeriesSummary';

3. Connect to the Hot RealTime server in the system.

4. Open a Windows PowerShell for DNA console, and then execute the following commands:

   Set-Silo RealTime

   savedata