SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
Job Properties

 
Reply to topic    SoftTree Technologies Forum Index » 24x7 Scheduler, Event Server, Automation Suite View previous topic
View next topic
Job Properties
Author Message
Pat Franklin



Joined: 28 Apr 2000
Posts: 14

Post Job Properties Reply with quote

Is there a way to get specific fields from the Job Properties into a spreadsheet format? I would like the Job Name and Semaphore File into a spreadsheet format.

Thu Sep 14, 2000 4:28 pm View user's profile Send private message
Len Fromzel ( SoftTree)



Joined: 13 Sep 2000
Posts: 5

Post Re: Job Properties Reply with quote

Pat,

Do you need it in Excel spreadsheet ?
It's easy to add an export option for the whole thing - later on you can edit it
( delete some information) within a spreadsheet.
Would you please explain the situation and why you need this feature, so we
can make a conclusion if something has to be added in the next release.
Thanks.

: Is there a way to get specific fields from the Job Properties into a
: spreadsheet format? I would like the Job Name and Semaphore File into a
: spreadsheet format.

Fri Sep 15, 2000 12:49 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7838

Post Re: Job Properties Reply with quote

As Len said, you can get the entire job database exported to let's say MS Access database then copy and paste only the desired information. If you have an Excel ODBC driver, you can also export to Excel spreadsheet.

For individual job properties consider creating a script job that will use JobDescribe statement to get the desired properties.

You can also make a Visual Basic or Visual Basic for Application macro that will get the same properties using 24x7 Scheduler API. Please see "24x7 Scheduler External Interfaces and API" help topic for more details. There is an example script for Microsoft Access avaialable in the on-line help file.

: Is there a way to get specific fields from the Job Properties into a
: spreadsheet format? I would like the Job Name and Semaphore File into a
: spreadsheet format.

Fri Sep 15, 2000 5:49 am View user's profile Send private message
Pat Franklin



Joined: 28 Apr 2000
Posts: 14

Post Re: Job Properties Reply with quote

I am trying to create a document for our operations area to know what semaphore files trigger what jobs. This is in case there is a breakdown in the job stream. I thought it would be easier to export it to Excel than to cut and paste what I need.

: Pat,

: Do you need it in Excel spreadsheet ?
: It's easy to add an export option for the whole thing - later on you can edit
: it
: ( delete some information) within a spreadsheet.
: Would you please explain the situation and why you need this feature, so we
: can make a conclusion if something has to be added in the next release.
: Thanks.

Fri Sep 15, 2000 8:45 am View user's profile Send private message
Pat Franklin



Joined: 28 Apr 2000
Posts: 14

Post Re: Job Properties Reply with quote

The JobDescribe statement sounds like something that I could use to achieve the desired results, but how do I dynamically read the Job database to get the properties for every job. I remember something about a contest to read the job database and reformat it, but I cannot find it on your website.

: As Len said, you can get the entire job database exported to let's say MS
: Access database then copy and paste only the desired information. If you
: have an Excel ODBC driver, you can also export to Excel spreadsheet.

: For individual job properties consider creating a script job that will use
: JobDescribe statement to get the desired properties.

: You can also make a Visual Basic or Visual Basic for Application macro that
: will get the same properties using 24x7 Scheduler API. Please see
: "24x7 Scheduler External Interfaces and API" help topic for more
: details. There is an example script for Microsoft Access avaialable in the
: on-line help file.

Fri Sep 15, 2000 9:14 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7838

Post Re: Job Properties Reply with quote

Use JobCreate to create new dummy job. This will give the maximum job id. Delete that dummy job using JobDelete. Do a loop ForNext for each job id from 1 to max and then call JobDescribe for every job for each parameter that you want to obtain.
Make sure to set that job property to "ignore errors" so you can skip gaps in job ids (if any exist)

: The JobDescribe statement sounds like something that I could use to achieve
: the desired results, but how do I dynamically read the Job database to get
: the properties for every job. I remember something about a contest to read
: the job database and reformat it, but I cannot find it on your website.

Sat Sep 16, 2000 5:58 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7838

Post Re: Job Properties Reply with quote

Please see my previous message for exporting to ODBC complient database (including MS Excel)

: I am trying to create a document for our operations area to know what
: semaphore files trigger what jobs. This is in case there is a breakdown in
: the job stream. I thought it would be easier to export it to Excel than to
: cut and paste what I need.

Sat Sep 16, 2000 5:59 am View user's profile Send private message
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.