SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
How to get a Job database summary of scheduler into a file

 
Reply to topic    SoftTree Technologies Forum Index » 24x7 Scheduler, Event Server, Automation Suite View previous topic
View next topic
How to get a Job database summary of scheduler into a file
Author Message
ganda_ravi



Joined: 25 Feb 2014
Posts: 25
Country: India

Post How to get a Job database summary of scheduler into a file Reply with quote
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 View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6500

Post Reply with quote
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 View user's profile Send private message
ganda_ravi



Joined: 25 Feb 2014
Posts: 25
Country: India

Post Reply with quote
Thanks for reply...
Can you please provide command line to Option 1
Thu Oct 16, 2014 8:25 am View user's profile Send private message
ganda_ravi



Joined: 25 Feb 2014
Posts: 25
Country: India

Post Reply with quote
How to export job database summary to (SQL Server, MS Access, Oracle, MySQL, etc...)
Thu Oct 16, 2014 8:26 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6500

Post Reply with quote
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.
Thu Oct 16, 2014 8:50 am View user's profile Send private message
ganda_ravi



Joined: 25 Feb 2014
Posts: 25
Country: India

Post Reply with quote
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 View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6500

Post Reply with quote
Certainly. There is an existing job template just for that.
Thu Oct 16, 2014 9:22 am View user's profile Send private message
ganda_ravi



Joined: 25 Feb 2014
Posts: 25
Country: India

Post Reply with quote
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 View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6500

Post Reply with quote
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 View user's profile Send private message
ganda_ravi



Joined: 25 Feb 2014
Posts: 25
Country: India

Post Reply with quote
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 View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6500

Post Reply with quote
I think you should have a look at the documentation
Thu Oct 16, 2014 12:15 pm View user's profile Send private message
adamrose045
Guest





Post Reply with quote
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
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » 24x7 Scheduler, Event Server, Automation Suite All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.