Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
- Cisco Community
- :
- About Derrick Au
08-07-2019
Derrick Au
Enthusiast
데릭 아우 • 소프트웨어 엔지니어
Recent Badges
Stats
Member since
08-07-2012
269
Posts
108
Helpful
35
Solutions
Created by
Derrick Au
in Intelligent Automation
in Intelligent Automation
06-14-2019
10:30 AM
06-14-2019
10:30 AM
Hi Vignesh, Try setting a Maximum runtime for the job (Job Definitions -> Run tab) Add job event: If job is running longer than maximum runtime Add email action: receive an alert when the condition is met. Best Regards, Derrick Au
... View more
Created by
Derrick Au
in Intelligent Automation
in Intelligent Automation
01-02-2019
10:33 AM
01-02-2019
10:33 AM
Hi Viji, From the webUI select Logs and filter on either the Current Day or Date Range and Message Text should include the following (not case sensitive): your request to remove job The same result can be found via SQL query: select * from msglog where msglog_crtdt >= '1/2/2019 13:00' and msglog_crtdt < '1/2/2019 13:16' and msglog_text like '%your request to remove job%' order by msglog_crtdt Best Regards, Derrick
... View more
Created by
Derrick Au
in Intelligent Automation
in Intelligent Automation
11-20-2018
07:52 AM
11-20-2018
07:52 AM
Hi,
Please check if jobs are configured to run on the same agent server or on a different agent server,
and runtime user Tidalprod has sufficient privileges on the agent server
Run as batch
Run as process
Act as part of OS
Replace a process-level token
BR,
Derrick Au
... View more
Created by
Derrick Au
in Intelligent Automation
in Intelligent Automation
11-20-2018
07:27 AM
11-20-2018
07:27 AM
Hi Vasudev
1. As soon as dependencies are met then job should fire off automatically. But in your case, that may not always be true. While there isn't an event to detect if a job is waiting on dependency for a specified time, you can utilize either 'Job Not Ready by Start Time' or 'Job Not Ready by End of its Time Window'
2. Which Tidal version are you using? Earlier, I had a similar issue with 6.3.4.81, where the job option to re-run whenever dependencies have been met did not work properly. The solution is to either rollback to 77 or patch to 91.
BR,
Derrick Au
... View more
04-17-2018
11:52 AM
You can also make use of the SACMD utility which allows for batch processing (mass updates).
Step 1.
The command can be as simple as: modrule -i job_ID -h agent_name
Step 2.
Insert the command above into a text file, and insert additional command lines as needed for each job ID
Step 3.
Now to run the batch file, type: sacmd file filepath_of_text file
Step 4.
Kick back, relax, and enjoy the popcorn!!!
Best,
Derrick Au
... View more
Created by
Derrick Au
in Intelligent Automation
in Intelligent Automation
03-09-2018
12:49 AM
03-09-2018
12:49 AM
This is an old duplicate posting... https://supportforums.cisco.com/t5/tidal-enterprise-scheduler/cross-day-scheduling-dependency-tidal-question/m-p/2894901/highlight/true#M2389
... View more
Created by
Derrick Au
in Intelligent Automation
in Intelligent Automation
03-09-2018
12:39 AM
03-09-2018
12:39 AM
This is an old posting... select * from jobmst where jobmst_active = 'Y' // for enabled jobs select * from jobmst where jobmst_active = 'N' // for disabled jobs
... View more
Created by
Derrick Au
in Intelligent Automation
in Intelligent Automation
03-08-2018
02:55 PM
03-08-2018
02:55 PM
Thanks Robert,
that's quite an extensive list.
Also check the msglog for any references to nodmst_id,
select * from msglog where nodmst_id=84
BR,
Derrick Au
... View more
06-08-2017
08:07 AM
Hi,
From the web UI, XML is certainly is a lot easier for us all to read, but behind the scenes the XML gets encoded. Check it out on Internet Explorer and press the F12 key to open up the DOM Explorer -> Network, hit the play button then post a REST API call
Regards,
Derrick
... View more
06-08-2017
07:36 AM
Thank you Jeff, and welcome Scott to the Cisco Support Community
I noticed your email domain - Congratulations Scott :-)
The data you seek can be found in the jobrun table, and joining it along with the jobmst table to get the names. You can try a simple SQL query and apply additional data columns or filters as needed:
SELECT jobmst.jobmst_prntname, jobmst.jobmst_name, jobmst.jobmst_id, jobrun.jobrun_instance FROM jobrun
JOIN jobmst on jobrun.jobmst_id = jobmst.jobmst_id
WHERE
jobmst.jobmst_name like '%ENTER_JOBNAME%'
and jobrun.jobrun_proddt >= 'ENTER DATE AS m/d/yyyy'
Regards,
Derrick
... View more
06-08-2017
07:20 AM
Hi,
On the left hand side of the navigation pane, Defintions -> Actions -> Email
This will allow you to attach a file along with the email notification.
Regards,
Derrick
... View more
06-06-2017
07:55 AM
Hi shmurray1
Since the error status can be verified under SSMS -- is the error string pretty static? If that is the case, then you can try setting within Job Definitions >> Run tab >> Tracking >> Scan output: Abnormal String(s), then enter the abnormal string. When Tidal sees the abnormal string, then your job will complete abnormally as expected.
Regards,
Derrick
... View more
01-21-2017
08:42 PM
Hi Laehr
Try this SQL select statement:
select jobmst.jobmst_id, jobmst.jobmst_prntname, jobmst.jobmst_name, msglog.msglog_text from msglog join jobmst on jobmst.jobmst_id = msglog.jobmst_id where msglog.msglog_text like '%override%' order by 2,3
BR, Derrick Au
... View more
01-21-2017
08:22 PM
Hi Jeff
If the abnormal string is enclosed by quotation marks then it is actually case-sensitive. If you remove the quotation marks, then whenever it encounters exception / error, then your job will be flagged as completed abnormally
BR,
Derrick Au
... View more
11-03-2016
06:09 AM
Hey Joe,
You can embed html tags in the message body of email actions,
<html> <body> <font face="verdana" color="green">This is a TEST!</font> </body> </html>
BR,
Derrick Au
... View more
06-14-2019
Hi Vignesh, Try setting a Maximum runtime for the job (Job Definitions
-> Run tab)Add job event: If ...
01-02-2019
Hi Viji, From the webUI select Logs and filter on either the Current Day
or Date Rangeand Message Te...
11-20-2018
Hi, Please check if jobs are configured to run on the same agent server
or on a different agent serv...
Created by
Derrick Au
in Intelligent Automation
11-20-2018
11-20-2018
Hi Vasudev 1. As soon as dependencies are met then job should fire off
automatically. But in your ca...
04-17-2018
You can also make use of the SACMD utility which allows for batch
processing (mass updates). Step 1....
Created by
Derrick Au
in Intelligent Automation
03-09-2018
03-09-2018
This is an old duplicate
posting...https://supportforums.cisco.com/t5/tidal-enterprise-scheduler/cro...
Created by
Derrick Au
in Intelligent Automation
03-09-2018
03-09-2018
This is an old posting...select * from jobmst where jobmst_active = 'Y'
// for enabled jobsselect * ...
03-08-2018
Thanks Robert, that's quite an extensive list. Also check the msglog for
any references to nodmst_id...
06-08-2017
Hi, From the web UI, XML is certainly is a lot easier for us all to
read, but behind the scenes the ...
06-08-2017
Thank you Jeff, and welcome Scott to the Cisco Support Community I
noticed your email domain - Congr...
06-08-2017
Hi, On the left hand side of the navigation pane, Defintions -> Actions
-> Email This will allow you...
06-06-2017
Hi shmurray1 Since the error status can be verified under SSMS -- is the
error string pretty static?...
01-21-2017
Hi Laehr Try this SQL select statement: select jobmst.jobmst_id,
jobmst.jobmst_prntname, jobmst.jobm...
01-21-2017
Hi Jeff If the abnormal string is enclosed by quotation marks then it is
actually case-sensitive. If...
Public Statistics
| Date Registered | 08-07-2012 03:36 PM |
| Date Last Visited | 08-07-2019 12:17 AM |
| Total Messages Posted | 269 |
| Total Helpful Votes Received | 108 |
Helpful Votes Given To
| User | Helpful Count |
|---|---|
| 5 | |
| 5 | |
| 5 | |
| 5 |
Helpful Votes From
| User | Helpful Count |
|---|---|
| 5 | |
| 5 | |
| 10 | |
| 20 | |
| 5 |
