Author |
Message |
ganda_ravi
Joined: 25 Feb 2014 Posts: 25 Country: India |
|
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...
|
|
Thu Oct 16, 2014 2:51 am |
|
![](templates/GreenTech/images/spacer.gif) |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7849
|
|
|
|
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.
|
|
Thu Oct 16, 2014 8:15 am |
|
![](templates/GreenTech/images/spacer.gif) |
ganda_ravi
Joined: 25 Feb 2014 Posts: 25 Country: India |
|
|
|
Thanks for reply...
Can you please provide command line to Option 1
|
|
Thu Oct 16, 2014 8:25 am |
|
![](templates/GreenTech/images/spacer.gif) |
ganda_ravi
Joined: 25 Feb 2014 Posts: 25 Country: India |
|
|
|
How to export job database summary to (SQL Server, MS Access, Oracle, MySQL, etc...)
|
|
Thu Oct 16, 2014 8:26 am |
|
![](templates/GreenTech/images/spacer.gif) |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7849
|
|
|
|
![](templates/GreenTech/images/quote_header.gif) |
![](templates/GreenTech/images/spacer.gif) |
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
![](templates/GreenTech/images/quote_header.gif) |
![](templates/GreenTech/images/spacer.gif) |
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.
|
|
Thu Oct 16, 2014 8:50 am |
|
![](templates/GreenTech/images/spacer.gif) |
ganda_ravi
Joined: 25 Feb 2014 Posts: 25 Country: India |
|
|
|
Thanks for reply
I have exported job database to file by using import/export option....
Can i automate the process daily.........
|
|
Thu Oct 16, 2014 9:01 am |
|
![](templates/GreenTech/images/spacer.gif) |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7849
|
|
|
|
Certainly. There is an existing job template just for that.
|
|
Thu Oct 16, 2014 9:22 am |
|
![](templates/GreenTech/images/spacer.gif) |
ganda_ravi
Joined: 25 Feb 2014 Posts: 25 Country: India |
|
|
|
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
|
|
Thu Oct 16, 2014 10:00 am |
|
![](templates/GreenTech/images/spacer.gif) |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7849
|
|
|
|
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
|
|
Thu Oct 16, 2014 10:17 am |
|
![](templates/GreenTech/images/spacer.gif) |
ganda_ravi
Joined: 25 Feb 2014 Posts: 25 Country: India |
|
|
|
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
|
|
Thu Oct 16, 2014 10:28 am |
|
![](templates/GreenTech/images/spacer.gif) |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7849
|
|
|
|
I think you should have a look at the documentation
|
|
Thu Oct 16, 2014 12:15 pm |
|
![](templates/GreenTech/images/spacer.gif) |
adamrose045
Guest
|
|
|
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
|
|
Sat Nov 15, 2014 7:41 am |
|
![](templates/GreenTech/images/spacer.gif) |
|