November 1, 2009 at 12:27 am
How do we run sql serever agent jobs for different time zones.For instance if a job is started in India at 11.50 pm on say Sept 12th it will be running upto Sept 13th and so it will log in data for two days... how do we process such jobs?
November 1, 2009 at 10:09 am
Jobs run local to the instance, on local time.
I'm not sure what you are asking.
November 2, 2009 at 1:52 am
If i start a job on Oct 30th night 11.59 pm it will start at that time and continue to Oct 31st after 12 am so it will be logging data for two days..Is it possible to avoid this and get data as if only on a single date Oct 31st.I hope its clear for you now....
thanks
November 2, 2009 at 3:06 am
Jobs run based on the server locale, so how long a job takes shouldnt matter.
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]
November 2, 2009 at 3:11 am
I was posed with a question as how can you solve the problem by having the log for a single day instead of two days log... is it possible..?
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply