question

Girish13-9668 avatar image
0 Votes"
Girish13-9668 asked NavtejSaini-MSFT commented

How to disable elastic job using SQL script

Hi ,

I have 2 question

Question 1 : I want to execute some SQL script everyday at 9 AM IST on the basis of DTU percentage is less than 5 then execute SQL script and once this script is successfully run with my DTU condition then want to stop or disable elastic job as my SQL server has no SQL server agent so due to which need to run by elastic job.

Question 2 : If i run elastic job so is it pay as service or is it free service?

Thanks in Advance

azure-scheduler
· 2
5 |1600 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.

Are you looking to use Azure services to schedule this job, or run this inside of Azure?

If this is for an on-prem service, this might not be the correct forum.

I noticed you tagged azure-scheduler for this question. Azure Logic Apps have taken the place of azure scheduler, if that is what you are looking into.


0 Votes 0 ·

Thank you @TravisCragg-MSFT for your response

It is not on-prem service.
My SERVER is on azure cloud and wants to do automate job using elastic job.

want to schedule this job every 10 Min and check if DTU percentage is less than 5% then want to execute SQL script and disable this job and do not run for whole day and again next day want to enable this job and check same condition of DTU

is it possible to disable and enable in elastic job ?

0 Votes 0 ·

1 Answer

NavtejSaini-MSFT avatar image
0 Votes"
NavtejSaini-MSFT answered NavtejSaini-MSFT commented

@Girish13-9668

Here is the document for the Elastic job actions that you can do using the TSQL.

We don't see direct out of the box solution for this. Please use Azure SQL UserVoice to create a feed back directly for the Product Team.

Please let us know if you need further information.

Thanks
Navtej S


· 1
5 |1600 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.

@Girish13-9668

Please let us know if you need further help here.

Thanks
Navtej S

0 Votes 0 ·