Re: ENT manager job status

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Hari Prasad (hari_prasad_k_at_hotmail.com)
Date: 09/15/04 

Date: Tue, 14 Sep 2004 20:39:02 -0500

Hi,

You could query the sysjobs table in MSDB database.

select name , enabled from msdb..sysjobs where enabled=1

You could run this query using OSQL command line utility

OSQL -S Server1 -Usa -Ppassword -Q"select name , enabled from msdb..sysjobs
where enabled=1" >c:\result.txt
OSQL -S Server2 -Usa -Ppassword -Q"select name , enabled from msdb..sysjobs
where enabled=1" >>c:\result.txt

Thanks
Hari
MCDNA

"Red" <RedWolf_56@yahoo.com> wrote in message
news:%23szm0PqmEHA.556@tk2msftngp13.phx.gbl...
> Hey all,
> I was wondering if someone could point me to correct data in the msdb
> database. Here is what I'm looking for. I want to be able go from server
> to
> server and check the status of all the jobs that are enabled. I know I
> can
> (and do) use ENT. Manger to do this but, hey, it tedious work. Open
> server,
> open management, open SQL sever agent, click on jobs.....
> I'd rather run query, from a my desk top, that will connect to the
> servers I need and run this query.
>
> Hope that is clear enough.
>
> TIA
>
> Red
>
>

Relevant Pages

  • Re: MailMerge hangs and crashes with Access on Server
    ... Since I am fairly new to working in this environment, I am not sure what you mean by an "Access group" with help to restructuring the query? ... "Peter Jamieson" wrote: ... All I know is that the performance of queries depends to a large extent on whether, for example, a join is performed on the client side, or on the server side, incurring no network traffic and potentially benefitting from caching on the server. ... There are no dialog boxes, and actually, I have now split the database, and have kept the Word templates and the Access frontend locally on my machine, and moved the backend to the server. ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Performance Benchmarks?
    ... Are attribute relationships defined properly on the dimensions? ... If you run Profiler against the server, how long is spent in "Query ... I have created aggregations (Partitions tab in cube design). ...
    (microsoft.public.sqlserver.olap)
  • High CPU in client (Excel, OWC, Proclarity, etc.) accessing Analysis Services
    ... the OWC10 with 3 dimensions on the row axis, ... The largest size of any of these 4 dimensions < 360 members. ... Performance Guide to optimize the query, the cube, the server, etc. ...
    (microsoft.public.sqlserver.olap)
  • Re: Performance Benchmarks?
    ... adding memory on the server can help you; more data can be cached on the ... Here is my test query. ... )} DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS FROM ... I have created aggregations (Partitions tab in cube design). ...
    (microsoft.public.sqlserver.olap)
  • Re: MailMerge hangs and crashes with Access on Server
    ... restructuring a complex query. ... discards 99% of them), or on the server side, incurring no network ... the database is locked and Word will not open the data source. ... have kept the Word templates and the Access frontend locally on my machine, ...
    (microsoft.public.word.mailmerge.fields)