when a sql server agent job is created and sheduled should we start running the job manaully for the first time or will it start automaitcally

Question

hi i have created a sql server agent job and scheduled it for every 10 mins. for the first time, when it runs should we need to run the job manually once before it starts with scheduled time. Basically how does the job run for the first time.

Also when the job is created the owner of the job is in disabled state. will this effect the schedule of the job? Appreciate quick help. Thanks.

Answer 1

The job will run on the schedule you provide - there is no need to run it manually to "prime" the schedule.

Disabled jobs are never executed by schedule - the scheduled executions will be skipped. They can still be executed manually.

If you have a disabled job which you wish to be triggered by a schedule, you must enable it first.