Can I run the job every minute?

Hi,

I am trying to show memory information in a graph from a few remote servers using SSRS.
I think that I can run the job every minute to fetch that information from each remote server.
Is it usual to run multiple jobs every minutes? Is it Okay to do in MS SQL?
Also what's other elements people wants to see from the server when they are working on performance issues?
IzzyTwinklyAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

dbaSQLCommented:
Well, you can do this, but I'd have to ask whether you'd really want to.  Understandably, you need to collect the memory detail from the remote machines.  I have been in exactly those shoes before, gathering different statistics from several remote instances, and needing to manipulate the data and represent it near real-time.

The requirement was 24/7, but that was just not practical, so I implemented multiple job schedules that worked within the business clock.  I worked around maintenance and even the weekly scheduled reboots.  And, of course, if this is a SSRS subscription, you may not be able to run every minute without conflicting with other scheduled subscriptions, or other reports.

It can be done, but I'm just saying it may be more manageable if you give the job multiple schedules, so that you can work around other server activities locally, as well as on the remote machines you are targeting,

ie, maintenance runs at 10pm and lasts an hour, every day of the week except Sunday.

On Sundays, the sql's are also booted at 6pm, and online/available by 7pm.

Give your job four schedules;  
#1 runs Mon - Fri, every minute, from 12:01AM to 9:50PM.
#2 runs Mon - Fri, every minute, from 11:30PM to 11:59PM.
#3 runs on Sunday, every minute, from 12:01AM to 5:55PM.
#4 runs on Sunday, every minute, from 7:01PM to 11:59PM.

Just an example.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
IzzyTwinklyAuthor Commented:
Hi dbaSQL,

Thanks for your answer.
I forgot to mention that I want to display only last 72 hours of data. In my job, it will get the data before/after the oldest data is removed so that it maintains only 72 hours of data all the time. Do you think it's reasonable? Do you see any value of doing this?
0
dbaSQLCommented:
>>Do you think it's reasonable? Do you see any value of doing this?
Difficult for me to answer that question without knowing a little bit more about your environment.  If you're just displaying memory statistics, then I would wonder whether 72 hours is a bit more than you need.  Again, I think back to that remote collection I was performing, and while the stats were made available 24/7, they were only actually viewable from the previous business day's close until the current day/current time.

If 72 hours of memory statistics is valuable, then yes, that would be reasonable.  If not, then I would trim it down a bit, as I am sure that will be easier to manage.  Just like working within your business clock, you'd want to tailor the collection to best match your business needs.  If that's 72hrs, then yes, it makes sense to go that route.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.