10-08-2012 09:05 PM - edited 03-01-2019 08:56 AM
Is it possible to get the list of jobs scheduled and their status in Tidal Enterprise scheduler using a programming language like C# ?
10-09-2012 09:56 AM
I think we need more details on what you want to implement. You could use the Tidal APIs to get run information or query the jobrun table with a join on jobmst+jobdtl depending on what else you are after.
Basic information can be obtained with API - here's the command from the 5.3.1 Command Line Program Guide PDF document.
SACmd jobmon [-d date] +display_options [filtering_options] [-b]
+s=status you can filter by multiple options
6X can leverage REST and goes through client manager
10-09-2012 04:17 PM
Thanks Marc, How to use the Tidal API? Is there any document?
I think the best option is to query the table, but I wanted to know about the API.
10-10-2012 07:05 AM
API depends on your version and you need to have the client installed from Server/DEsktop initiating the API
the PDF document should have been included on you CD2 called Command Line Program Guide
I will use 5.3.1 as an example:
open a command prompt
Browse to C:\Program Files (x86)\TIDAL\Scheduler\client
type in set alias=DEV
type in SACMD
type HOST I always type in HOST so I can verify what master I am running against (nio need if only one connection)
type in jobmon with your options I included below from doc
[-d date] +display_options [filtering_options] [-b]
It may be of limited use in 5.3.1 because to isolate you need to know Job ID or Alias or some other filter critiera... Job ID is in database jobmst.dbo.jobmst_id which is the unique identified and can be different from alias... depending on your requirements (dashboard?) and how you have organized your jobs a SQL query would be the better option.
DISPLAY
r | Job rule ID |
i | Job run ID |
p | Parent job group ID |
j | Job type (job or job group) |
c | Occurrence number |
o | Job or job group owner |
u | Runtime user |
h | Agent The Agent the job runs on |
z | Scheduled vs. unscheduled job |
t | Job start time |
s | Job status |
v | Job duration |
n | Job name |
a | Job alias |
q | Queue |
x | Exit code |
FILTER | |
-r | rule_id Job rule ID |
-p | group_id Parent job group ID |
-j | type Job type. You can choose: job group: group, or 1 job: Job, or 2 |
-o | owner Job or job group owner |
-u | run_user Runtime user |
-h | agent The Agent name the job runs on |
-s | job Status ( Completed Abnormally=103, Normal=101) |
-a | alias Job alias |
-x | exit_code Exit code |
-b | Suppresses the header information |
10-10-2012 06:40 PM
Exactly Dashboard. You one wonderful resource! Thanks.
Version is 5.3.1
Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community: