How do I schedule and run a T-SQL Job in Elastic Database Jobs?

Question

This Lear Page supposedly shows how to setup and check on elastic database jobs

https://learn.microsoft.com/en-us/azure/azure-sql/database/elastic-jobs-tsql-create-manage?view=azuresql#sp_add_job

However, there is nothing in here to indicate "What" will actually run. there is nothing in there were you specify the actual command or sets of commands (T-SQL) that you want to run. The link really does not make a lot of sense.

Answer 1

Hi Lee
Each Job is capable to have multiple steps within it. The link you have referenced is only the first part - creating the Job shell and the schedule that it will run.
You then need to use sp_add_jobstep to add each individual step in the job. This is where you define the actual work the Job will do.
I hope that clarifies your issue?