Do everything in one place

Customize your Jira and SQL Server secondary integration with the following triggers and actions.

Triggers

When this happens…

Jira
  • New issue
    New issue in Jira
  • New project
    New project in Jira
  • New/updated comment Real-time
    New/updated comment in Jira
  • Updated issue
    Updated issue in Jira
  • New/updated issue Real-time
    New/updated issue in Jira
  • New/updated worklog Real-time
    New/updated worklog in Jira
  • Any other trigger you can think up

SQL Server secondary
  • New row
    New row in a table in SQL Server secondary
  • New rows Batch
    New batch of rows in a table in SQL Server secondary
  • New rows via custom SQL Batch
    New batch of rows via custom SQL in SQL Server secondary
  • Scheduled query Batch
    Scheduled query using custom SQL in SQL Server secondary
  • New/updated row
    New/updated row in a table in SQL Server secondary
  • New/updated rows Batch
    New/updated batch of rows in a table in SQL Server secondary
  • New/updated rows via custom SQL Batch
    New/updated batch of rows via custom SQL in SQL Server secondary
  • Any other trigger you can think up

Actions

Do this…

Jira
  • Custom action
    Custom action in Jira (Custom)
  • Assign user to issue
    Assign user to issue in Jira
  • Create comment
    Create comment for issue in Jira
  • Create issue
    Create issue in Jira
  • Create user
    Create user in Jira
  • Get user details
    Get user in Jira
  • Download attachment
    Download attachment from issue in Jira
  • Get changelog of an issue
    Get changelog of an issue in Jira
  • Get issue
    Get issue details from Jira
  • Get issue comments
    Get list of issue comments for issue in Jira
  • Search assignable users
    Search assignable users for issue in Jira
  • Search issues
    Search issues in Jira
  • Search issues by JQL
    Search issues by JQL in Jira
  • Update comment
    Update comment for issue in Jira
  • Update issue
    Update issue in Jira
  • Update issue status
    Update status of issue in Jira
  • Upload attachment
    Upload attachment to issue in Jira
  • Any other action you can think up

  • Show all 17
SQL Server secondary
  • Delete rows
    Delete rows in a table in SQL Server secondary
  • Execute stored procedure
    Execute stored procedure in SQL Server secondary
  • Export query result Bulk
    Export result of custom SQL in SQL Server secondary
  • Insert row
    Insert row in a table in SQL Server secondary
  • Insert rows Batch
    Insert batch of rows in a table in SQL Server secondary
  • Run custom SQL
    Run custom SQL in SQL Server secondary
  • Run long query using custom SQL
    Run long query using custom SQL in SQL Server secondary
  • Select rows
    Select rows in a table in SQL Server secondary
  • Select rows using custom SQL
    Select rows using custom SQL in SQL Server secondary
  • Replicate rows Batch
    Replicate batch of rows to table in SQL Server secondary
  • Update rows
    Update rows in a table in SQL Server secondary
  • Update rows Batch
    Update batch of rows in a table in SQL Server secondary
  • Upsert row
    Upsert row in a table in SQL Server secondary
  • Upsert rows Batch
    Upsert batch of rows in a table in SQL Server secondary
  • Any other action you can think up

  • Show all 14

Let us tailor your Jira and SQL Server secondary integrations

Pre-built Jira and SQL Server secondary Automations

See more

The wonders of Workato

Easily set up as many intelligent automations you need.
1000s of ready-to-use templates
Accelerate work with intelligent automation
Do it yourself, faster
Build bots. Put them to work

Market leaders run on Workato