SQL Job - From Min. To Sec.

• tali_benyehuda

  Valued Member

  Points: 67

  More actions

  January 28, 2009 at 3:14 am

  #199473

  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.

• aali_online

  SSC Veteran

  Points: 221

  More actions

  January 28, 2009 at 4:55 am

  #933698

  Setting

  @freq_subday_type=2,

  will set the frequency to seconds.

  Then setting

  @freq_subday_interval=20,

  will set the interval to be 20 seconds.

• tali_benyehuda

  Valued Member

  Points: 67

  More actions

  January 28, 2009 at 5:19 am

  #933707

  Thank you very much!:)