How to get a Job database summary of scheduler into a file

How to get a Job database summary of 24x7 scheduler into a file

Ex: total jobs=100
disabled jobs=50
active jobs=50

I need a report file from scheduler giving the list of active,disabled and total jobs...

Option 1. Using the command line interface list all jobs and their states and redirect output to a file, then manipulate results in Excel or other tool
Option 2. Export job database to an external database system (SQL Server, MS Access, Oracle, MySQL, etc...) pull the required summary info using exported data and SQL queries

Please let me know if you need more info.

Thanks for reply...
Can you please provide command line to Option 1

How to export job database summary to (SQL Server, MS Access, Oracle, MySQL, etc...)

	Quote:
	Can you please provide command line to Option 1

Please run cons.bat or cons.sh depending on your operation system. At the prompt type
help connect
and then type help list
To get help on connect and list commands.

after getting familiar with the command syntax and purpose, run something like
connect user password 1097
list
exit

to redirect output to a file, you can use cons.bat <my_commands> output.txt

	Quote:
	How to export job database summary to (SQL Server, MS Access, Oracle, MySQL, etc...)

I didn't say you can export summary, I said you can export the job database. You can then create reports of any type including summary reports using the exported data and SQL queries. One way to export the job database is to use Tools / Export Job Database menu.
Once you get the job properties exported to an external database, study data in the database tables and then write appropriate SQL queries to create the required report. I can help you with SQL queries when you have the data exported and get familiar with it.

Thanks for reply

I have exported job database to file by using import/export option....

Can i automate the process daily.........

Certainly. There is an existing job template just for that.

I'm unable to create new access job database interface in scheduler

Can you please suggest me the steps to create new access database interface

First create an ODBC profile pointing to your MS Access database file. Make sure it's 32-bit profile, which is what required for your version
Create new database profile in 24x7 under ODBC database interface. Enter JDBC URL referencing your ODBC profile created in the first step, for example,
jdbc:odbc:your_odbc_profile_here

I have created the ODBC profile to point access database

when I tried to to create interface its asking below fields

Drivers Path:
Drivers Class:

can you please specify what should be there in that fields

I think you should have a look at the documentation

You can then create reports of any type including summary reports using the exported data and SQL queries. One way to export the job database is to use Tools / Export Job Database menu.

GuL