question

Al-8191 avatar image
0 Votes"
Al-8191 asked ·

Alternatives to SSMS for scheduling full-text index population

Hi everybody!

I am trying to set up a scheduled population of my full-text index in SQL Server.
The manual on Microsoft docs says I should go to the properties menu of my index in SSMS.
However, as described in my previous question, I get an error when trying to do that.
What are the alternative ways to set up a population schedule?


azure-sql-database
· 2
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@Al-8191 Do you need any further help with this. Here is the document explaining the Elastic Jobs in detail.


0 Votes 0 ·
Al-8191 avatar image Al-8191 NavtejSaini-MSFT ·

Thanks, I'll look into it

0 Votes 0 ·

1 Answer

ErlandSommarskog avatar image
0 Votes"
ErlandSommarskog answered ·

I did a quick check, and it is just spinning up the regular scheduling dialog for Agent. So you could do this on a local instance on your own machine and use the script button to see what it creates. You may also have to check the jobs it creates.

But then you will face the next problem: there is no Agent in Azure SQL Database. But there are Elastic jobs, which fills the same role (and may add a little more to your Azure bill.)

· 1 ·
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

...or create a RunBook with Azure Automation, if one prefer that way (for instance If one insist on having some type of GUI).

0 Votes 0 ·