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
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide