Good catch Remi - I'm glad that Celko didn't come across this one...he'd have launched into a tirade immediately....

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....

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...

Farrell has already posted a link to what seems to be another forum in which this question was asked....let's all work together in making sure we discourage cross-posting as much...

No...talking about 2000!!!

Oh this is such wonderful news...just heard that the mother and kids have been found and are well....the husband went to get help and they're still looking for him.....I sincerely...

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...

If your question is really about syntax, then the best way you can learn is to create the view via Enterprise Manager - right click "views".."new view"...and the wizard will...

Not sure if you've fully expanded the results or not...but if you pick tools-options and select "results to text" under the results tab, you'll find it more readable and therefore...

Absolutely right...it's a sad statement indeed if we start showing surprise when people/companies do the only thing that should be done under the circumstances....

ps:It does look like a gloomy outcome...

Yes I could David...actually until last week I had all my eggs in one basket (read - only one email account) - now I have one at work as well...so...

okay - I got the monthly recap on Saturday...maybe the other times that I remember something from ssc on a Saturday was the "database daily"....anyway, just wanted to say that...

In all the years that I've been touting the joys of teleworking, this factor has always been a star seller...that location does not matter...wish more people would wake up to...

I thought it was a great comprehensive overview....that's a pretty hefty accusation you make there....no one really has the time to go through BOL indepth..usually that's the first stop for...

are you translating from French or something Remi...what does "iirc what I childhood used to be like" mean....?!?!