Bulk Scheduled Query Disabling

To disable scheduled queries in bulk, you need the role of the Server Admin.

To disable scheduled queries, perform the following steps:

  1. Go to Admin Settings > Miscellaneous tab.

  2. Navigate to the Query Scheduling section. Slide the toggle Query Scheduling to turn it off.

Alternatively, use the command line to disable scheduled queries:

  1. Get your user ID. You will need it to run the command that disables scheduled queries.

    1. Enter the Alation shell

      sudo /etc/init.d/alation shell
      
    2. Get the ID of the user substituting the sample values with actual values

      alation_psql
      select id, username, email from auth_user where email like 'example%';
      
    3. Note the ID and exit psql:

      \q
      
  1. On the Alation host, run the following commands to disable all scheduled queries. Substitute the # in id=# with your user ID:

    sudo /etc/init.d/alation shell
    alation_django_shell
    from rosemeta.models import SiteSettings
    setting = SiteSettings.get('misc_settings')
    setting['enable_query_scheduling'] = 'no'
    SiteSettings.set('misc_settings', setting, User.objects.get(id=#))