December 4, 2006 at 2:23 am
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
December 4, 2006 at 12:32 pm
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.
December 4, 2006 at 10:54 pm
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
December 5, 2006 at 4:24 am
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 !!!**
December 5, 2006 at 4:33 am
hello
I m confused here ......are you talking about sql server 2005???? we have server 2000
Regards,
Papillon
December 5, 2006 at 5:43 am
No...talking about 2000!!!
**ASCII stupid question, get a stupid ANSI !!!**
December 5, 2006 at 5:50 am
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
December 5, 2006 at 6:10 am
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 !!!**
December 5, 2006 at 6:24 am
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
December 5, 2006 at 6:32 am
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.
December 5, 2006 at 6:48 am
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 !!!**
December 5, 2006 at 8:41 pm
Yes!!
That i exactly exactly i want..
Thanks for every body!!!!!!!!!!!!!!!!!!!!
Regards,
Papillon
Viewing 12 posts - 1 through 11 (of 11 total)
You must be logged in to reply to this topic. Login to reply