I have an elastic job agent set up for an Azure SQL database. The job has three steps (job.jobsteps) and has run correctly in the past.
If the job fails on the second step, I would like to restart it on the third step and not do the first two steps again. Is there a way to accomplish this? It doesn't look like there is.
An example (pseudo-code)
In this example - this is my Job X. These are Job X's jobsteps (in real life they are T-SQL procedures). The job runs - it does something like this:
step 1 - Create Tables - I create table A - it is empty
step 2 - Populate local Tables from extended tables - I use my extended table B to populate table A
step 3 - do some data manipulation on the local tables and write them to new tables - I do some data manipulation and write my results to a new Table C
Now - let us say there is a problem with the data manipulation and the results in Table C are wrong or need some new logic added. I change the logic in Step 3. I don't need to recreate table A or repopulate it from B - I just want to start Job X at step 3.
All job steps have a @retry_attempts set to 0 because I don't want them to try again if they fail. If step 3 fails or gives me a questionable result - I will adjust the T-SQL procedure in step 3 and then want to start job X from Step 3.
Can that be done?
Please note - this is not actually what I am doing - just an illustrative example to explain the problem I am having. Please do not answer with workarounds for creating or populating tables. I simply need to know if Job X can be started from Step 3 in ElasticJobs preview on SQL Azure and if yes – how?
Any advice much appreciated.