Hi i am working with SQL Elastic Jobs and the only way to schedule a job is as follows - which sets the schedule to run at everyday but there is no option to specify what time to run it on every day and seems to default to when the following statement was run. so if this was run at 10:30 am the schedule will set the job to run at 10:30 am every day. Is there any way to specify a time to make it run at 4:00 am everyday ?
EXEC jobs.sp_update_job
@job_name='Run Sample Job',
@enabled=1,
@schedule_interval_type='Days',
@schedule_interval_count=1
Thanks