set job schedule in Seconds also???

Question

set job schedule in Seconds also???

Papillon

Hall of Fame

Points: 3303
More actions
December 4, 2006 at 2:23 am

#171116

Hello friends!
I want to set my job agaent to schedule for second basis but in EM i found by right clicking job in EDIT Recuring Job Schedule i m getting option in Hr and MM but not in SS so where i can set this in seconds (SS) or through QA????
Regards,
Papillon

Viewing 12 posts - 1 through 11 (of 11 total)

You must be logged in to reply to this topic. Login to reply

Loner SSC-Insane Points: 21279 More actions · Answer 1

When you open the job in EM, click on the Schedule tab, you can set the schedule there and you can schedule in hh:mm:ss.

Papillon Hall of Fame Points: 3303 More actions · Answer 2

Hello

I think there is no way to get this seconds option for Edit Recurring Job Schedule (through EM)...So i m asking is there any other way to run job every say 15 sec. if the job expected to finish in 2 seconds....

Regards,

Papillon

sushila SSC-Dedicated Points: 35293 More actions · Answer 3

Yes there is...as Loner said, you have to click on the "edit" button on the "schedules" tab and then click on the "change" button at the bottom right of the window...one you're there you can change hrs, mts and seconds...

**ASCII stupid question, get a stupid ANSI !!!**

Papillon Hall of Fame Points: 3303 More actions · Answer 4

hello

I m confused here ......are you talking about sql server 2005???? we have server 2000

Regards,

Papillon

sushila SSC-Dedicated Points: 35293 More actions · Answer 5

No...talking about 2000!!!

**ASCII stupid question, get a stupid ANSI !!!**

Papillon Hall of Fame Points: 3303 More actions · Answer 6

I explain whole things here

I click in EM >>>Under Managment>>>Jobs>>> Right click Job_Name>>> Properties>>> third tab is schedules>>>> Edit>>>>Under Recurring>>>> click on Change>>>>Under Daily Frequency>>>>> Occurs Every.... here i am getting only two options in drop down HH and MM

So.......

T.I.A

Regards,

Papillon

sushila SSC-Dedicated Points: 35293 More actions · Answer 7

Papillon...you can finetune your schedule "to the second" in the box next to this that's labeled "starting at"...so you can set your schedule to recur every 1 minute and set starting at to 12:01:15...it appears though that this may not be enough for your purpose...

To educate myself, may I ask what the job is that you want to schedule every few seconds ?!

**ASCII stupid question, get a stupid ANSI !!!**

Papillon Hall of Fame Points: 3303 More actions · Answer 8

Hi

See i am not doing or running such kind of jobs!!

but i heard that through

BEGIN

WAITFOR TIME '000:00:10'

EXEC sp_start_job @job_name = 'Job_Name'

END

we can run jobs after every few seconds...

Please correct me if i m wrong

T.I.A

Regards,

Papillon

Loner SSC-Insane Points: 21279 More actions · Answer 9

Now I understand what you want to do, you want the job to run every 15 minute interval. The frequency interval only has hours and minutes.

Instead of using schedule job, you can write a simple procedure or DTS package to start the job every 15 second.

Create procedure RunJob

AS

DECLARE @EndTime VARCHAR(20)

SET @EndTime = CONVERT(VARCHAR(20), GETDATE(), 108)

WHILE @EndTime < '17:00:00'

BEGIN

WAITFOR DELAY '00:00:15'

EXEC msdb.dbo.SP_START_JOB @JobName = 'Job'

END

Then create a job to run this procedure.

my 2 cents.

sushila SSC-Dedicated Points: 35293 More actions · Answer 10

And here's yet another script that I found here http://www.sqldev.net/sqlagent/SQLAgentRecuringJobsInSecs.htm -

with adding the @freq_subday_type = 2 --seconds parameter to the stored procedure sp_add_jobschedule....

**ASCII stupid question, get a stupid ANSI !!!**

Papillon Hall of Fame Points: 3303 More actions · Answer 11

Yes!!

That i exactly exactly i want..

Thanks for every body!!!!!!!!!!!!!!!!!!!!

Regards,

Papillon