Simple tools for job monitoring

Question

Post reply

Simple tools for job monitoring

sm_iransoftware

Ten Centuries

Points: 1228
More actions
May 1, 2012 at 1:39 am

#260231

Hi
I need a simple Tool to see last status of Job running.a quick view , without
1- register servers in any time
2- and see history of ever job
please help me.
bye

Viewing 9 posts - 1 through 8 (of 8 total)

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

Robin Sasson Hall of Fame Points: 3359 More actions · Answer 1

Can I ask why you don't / want to register servers?

How will you access the data regarding the job without registering the servers?

:exclamation: "Be brave. Take risks. Nothing can substitute experience." :exclamation:

sm_iransoftware Ten Centuries Points: 1228 More actions · Answer 2

Hi

I mean that : Register for one time no for ever time.

no need run sqlserver for ever time

a tool that save myserver registration . and show me all job status and alarm about failed jobs.

thanks.

bye

Robin Sasson Hall of Fame Points: 3359 More actions · Answer 3

OK - Your answer didn't really address my question.

SQL Management Studio will save server registrations and show you job statuses.

If you want something outside of SQL Server then take a look at products from Quest Software or Idera.

Like all products that query SQL Server, you will need to register and connect to SQL Server. That means you should have a good understanding of security.

:exclamation: "Be brave. Take risks. Nothing can substitute experience." :exclamation:

sm_iransoftware Ten Centuries Points: 1228 More actions · Answer 4

Hi again.

I know sqlserver sequrity and sql server registration . 😎

But unfortinataly I dont know "english" well. 😛 then I can't say me nessecey clearly .

I am dba and manage 6 db servers . and I should check 25 Job at first of morning.

I wrote most of them.

and I am delphi programmer.

I wrote a program that monitoring Jobs. and I want see " what are similar it? and I get idea to complte that. "

you can see my program at this address :

http://uplod.ir/22mawt7auw5g/DataBase_Information.ex_.htm

Please

1- wait to complete reverse compation

2- reform .exe befor rub that.

bye;-)

Ant-Green SSC Guru Points: 113507 More actions · Answer 5

quite a few options on this

create a central management server and write a query which loops through the MSDB tables to get the information you need, that way you only execute the query on the CMS which executes it for you on all of the CMS's registered servers

create a batch file which uses SQLCMD which logs in, runs a query and displays the results in a DOS window

login to each server in ssms and run the query

login to each server in ssms and view job acitivty monitor

add an operator to SQL, and set the jobs to email on completion

get something like a 3rd party monitoring tool (Quest Spotlight/Foglight, Red-Gate SQL Monitor, Idera SQL Diagnostic Manager, SQL Sentry ........)

Robin Sasson Hall of Fame Points: 3359 More actions · Answer 6

Anthony beat me to it!

I've used free Idera products in the past to monitor multiple servers, jobs and activity.

:exclamation: "Be brave. Take risks. Nothing can substitute experience." :exclamation:

sm_iransoftware Ten Centuries Points: 1228 More actions · Answer 7

Ohhhhhhhhhhhh !!!

SSC-Addicted !!! You are very PowerFull !!! :w00t:

Be successfull with your dear idera .

and thank you SSCommitted . 🙂

Sodtke SSC Eights! Points: 982 More actions · Answer 8

I use SQL Agent Insight found here:

http://brentec.ca

Job monitoring with the ability to set thresholds and alerting, and to even bypass certain SQL Agent metrics you might not want to monitor or be alerted on.

Regards.