Schedule NRQL searches

As a New Relic user, you may run the same NRQL queries over and over again to monitor critical patterns, check for specific conditions, or generate regular reports. For example, you need to check daily for failed transactions, monitor weekly error rates, or track hourly performance metrics across your applications. This manual process is time-consuming and makes it easy to miss important insights when you're not actively monitoring.

Scheduled NRQL searches solve this problem by automating your repetitive queries. You can schedule queries to run automatically and receive results via email, so you'll stay informed about critical patterns without constant manual monitoring.

What you can do

Scheduled NRQL searches let you:

• Automate repetitive queries: Convert manual queries into automated workflows that run on your schedule.
• Stay informed proactively: Receive email notifications with query results delivered directly to your inbox.
• Flexible scheduling: Use custom cron expression schedules to define when queries run.
• Multiple output formats: Export results as CSV or JSON files attached to email notifications.
• Team collaboration: Send scheduled search results to multiple email recipients.
• Centralized management: View, edit, and manage all your scheduled searches from a single location in the Administration UI.

Prerequisites

To use scheduled NRQL searches, you need:

• User permissions: Workflow Automation permissions are required to create and manage scheduled searches.
• Account access: Access to the account where you want to schedule searches.
• Data access: Appropriate permissions to query the data you want to schedule. For example, if scheduling a query against log data, you need access to that log data.

Schedule a new search

To schedule a new automated NRQL search:

Access scheduled searches:

1. Go to one.newrelic.com > Administration > Scheduled Searches.
2. To configure a new search, from the Scheduled Searches page, click Schedule a search.

Configure your query:

1. On the configuration modal, draft your NRQL query using standard NRQL syntax.
2. Test your query to ensure it returns the expected results.
3. To set up notification settings for the scheduled search, click Continue.

Set up notification:

1. Enter a name for your scheduled search.

2. Add an optional description to help identify the search purpose.

3. Set a destination to receive the query results. Currently, you can only send results to email destinations.

   Select an existing destination

   From the dropdown, check the existing destinations. Each destination may have a group of email addresses associated with it. Choose one or more destinations to receive the query results. If the destination you want isn't listed, you can create a new one.

   Add a new destination

   Click + Add destination and perform the following steps on the opened modal:

   1. Click + Add email, search recipients by email ID or username, and add them.

   2. Enter a unique name for the destination and save.

      The new destination is added to the list of available destinations in the notification setup modal. To edit the destination, select the menu.

4. Enter a subject and message body for the email notification.

5. Select a query result format you want to include in the email.

6. To set a schedule for the email notifications, click Continue.

Set a schedule:

Currently it supports only cron expressions. Following are some common cron expression patterns for reference. Enter a cron expression and click Continue.

• 0 * * * * - Every hour at the top of the hour

• 0 9 * * * - Every day at 9:00 AM

• 0 9 * * 1 - Every Monday at 9:00 AM

• 0 0 1 * * - First day of every month at midnight

• */15 * * * * - Every 15 minutes

• 0 9 * * 1-5 - Every weekday at 9:00 AM

Review, confirm, and schedule the search: Review your configuration. If you need to make further adjustments, switch back to the relevant step. After finalizing your configuration, click Schedule to create your automated search. The Scheduled searches page will display your new search in the list.

Manage scheduled searches

The Scheduled searches page in the Administration UI displays all your automated searches with their name, description, schedule, status, and next run time. From you can:

• Edit a search to update the query, schedule, notification settings, or output format.
• Delete a search.

What's next?

Now that you've set up scheduled NRQL searches:

• Learn more about NRQL queries to create more sophisticated automated searches.
• Configure alert email destinations to expand your notification options.
• Explore workflow automation for more advanced automation possibilities.