Solved: Automate To Stop a Job

Warren Tolentino · ‎09-09-2015

i was asked to create an event/job that will stop/cancel a job run. has anyone has an example how to automate to stop a job? please advise.

thank you,
warren

Derrick Au · ‎09-15-2015

Hi Warren,

The commandline utility is a separate install (and should've come with your installer files). Please check.

Thanks,

Derrick Au

View solution in original post

Derrick Au · ‎09-09-2015

Hi Warren,

There are a couple of ways to stop a job, but first I should let you know I am still on 5.3.X and if you are already on 6.2 then there might be some modifications needed.

1) Create a new job event, and select action Hold/Stop or Cancel/Abort based on your desired

event trigger

2) From the command line,

To hold, sacmd jobhold jobrun_ID

To cancel, sacmd jobcancel jobrun_ID [YES|NO], where YES instructs Tidal to cancel

dependent jobs as well, and NO instructs Tidal to leave the dependent jobs as is on the schedule.

Default is NO.

Perhaps 6.2 users can add an update ;-)

BR,

Derrick Au

Warren Tolentino · ‎09-09-2015

thanks Derrick.

I create these jobs:

110 - SEERT Delay Utility
120 - SEERT Cancel Job

I run the 110 first and it has the 8037889 job run id then followed by 120. The 120 did not cancel the first job.

The 120 has these items:

Command: cmd
Command Parameters: sacmd 8037889 YES

The 120 job output is this:

Microsoft Windows [Version 5.2.3790]

E:\Program Files\TIDAL\Agent\TIDAL_AGENT_1>

Completed at 9/9/2015 12:00 PM

Please advise.

Derrick Au · ‎09-09-2015

Hi Warren,

Missing jobcancel

ie, sacmd jobcancel 8037889 YES

The 120 has these items:

Command: cmd
Command Parameters: sacmd 8037889 YES

BR,

Derrick Au

Warren Tolentino · ‎09-15-2015

hi derrick I updated the job with the jobcancel it still did not work. please advise thanks.

Derrick Au · ‎09-15-2015

Hi Warren,

It doesn't appear sacmd is recognized. Try in the command field: sacmd,

parameters: jobcancel <JobRun_ID> NO|YES,

Working directory is where the directory path for sacmd should be specified. Attached are some screenshots for your review.

BR,

Derrick Au

Warren Tolentino · ‎09-15-2015

Hi Derrick,

It looks like there's no sacmd.exe. Is the sacmd.exe on the server where the tidal master is installed at?

Volume in drive E is Data

Volume Serial Number is 0C27-6745

Directory of e:\Program Files\TIDAL

12/12/2014 09:49 AM <DIR> .

12/12/2014 09:49 AM <DIR> ..

12/12/2014 09:49 AM <DIR> Agent

04/10/2000 12:01 PM 19,456 NTEventLog.dll

10/18/2007 11:02 AM 780 oem.cfg

08/17/2010 07:45 AM 905,728 ServiceMgr.exe

10/14/2011 05:04 PM 64,512 TClusUtl.dll

02/09/2006 09:59 AM 740,352 TIDALInst.dll

5 File(s) 1,730,828 bytes

3 Dir(s) 31,586,623,488 bytes free

Completed at 9/15/2015 1:00 PM

Thanks,
Warren

Derrick Au · ‎09-15-2015

Hi Warren,

The commandline utility is a separate install (and should've come with your installer files). Please check.

Thanks,

Derrick Au

Derrick Au · ‎09-17-2015

Thanks for the kudos Warren

The command line utility can be installed at an agent/server, not necessarily at the Master.

BR,

Derrick Au

Warren Tolentino · ‎09-17-2015

thanks derrick. it looks like the sacmd.exe is not installed. i have requested it to our admin to install it.