Announcement

Collapse
No announcement yet.

Prompt input for variable while manually running batch job

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Prompt input for variable while manually running batch job

    I have several queries that I run daily and they each have an id that I change frequently from a joined table. I have a variable [$id] that helps speed this up a little, but I'd rather have a batch job that I could either schedule or run manually. The problem is, when I run the batch job, it skips altogether the queries that have this variable. Is there a way to run a batch job for queries that have a variable and will prompt for input to set the variable? I don't mind running the job from command line if that allows me to set the variable and run these queries.

  • #2
    Navicat does not support to run queries with paramenters in batch job. I have forwarded this request to our development team. We will keep improving Navicat in future.

    Comment

    Working...
    X