Hi!
Im looking for a way to run a job in less then 1 minute.
Someone has an idea?
I know that I can change the settings via its script, but i dont exactly know which one i should change?
EXEC @ReturnCode = msdb.dbo.sp_add_jobschedule @job_id=@jobId, @name=N'DBA_ConnAlert',
@enabled=1,
@freq_type=2,
@freq_interval=10,
@freq_subday_type=4,
@freq_subday_interval=1,
@freq_relative_interval=0,
@freq_recurrence_factor=0,
@active_start_date=20090127,
@active_end_date=99991231,
@active_start_time=0,
@active_end_time=235959
Regards.