So SQL task and job error notifications are working fine, except on one job. When the http task in this job fails it will throw an email notification on job failed (if I set it) but not the same sql job failed, and task error notifications that work on other jobs!

The failures of this job I've been testing are when the url is invalid in the task. The task is as follows (although i just left everything as default that I know of except for the timout):
GET
Content-type header: application/x-www-form-urlencoded; charset=UTF-8
Auth type: NTLM
Timout in seconds: 1
KeepAlive: check
AllowAutoRedirect: check
Credentials: No credential


I've played around with these settings a bit (ive tried the default of 600, and tried unchecking the KeepAlive and AllowAutoRedirect) and have not gotten it to work. I really don't understand how the same notification trigger (job failed) could work with one notification but not anouther. Here's my job failed notification SQL if that helps, thanks:

insert into vclog
(DateTime,Source,JobProcId,JobName,TaskName,Status,ErrorCode,ErrorMsg,Notification,Message)
values
('{DATETIME()}','VisualCron','{JOB(Active|UniqueProcessId)}','{JOB(Active|Name)}','{TASK(PrevTask,Name)}','{JOB(Active|Status)}','{JOB(Active|ExitCode)}','{TASK(PrevTask,StdErr)}','{TASK(Active,Name)}','{TASK(PrevTask,StdOut)}');

Not sure I understood what the problem was really but {TASK(Active,Name)} maybe should be {TASK(PrevTask,Name)}

---

Let me explain more: We have decided to log errors by using SQL Notifications to insert information about running visualcron tasks and jobs into a database so we can log errors and other information.

So basically in the flow section of a task or job, we trigger sql notifications On Start, On error, etc... to get logs. (we decided to do custom logging rather than use visualcron's logs)

My problem is for some reason on one job the sql notification won't run on a "Job Failed" in the Job "flow" section, but email notifications will, same for task error. Do you understand? Thanks.

Let me explain more: We have decided to log errors by using SQL Notifications to insert information about running visualcron tasks and jobs into a database so we can log errors and other information.

So basically in the flow section of a task or job, we trigger sql notifications On Start, On error, etc... to get logs. (we decided to do custom logging rather than use visualcron's logs)

My problem is for some reason on one job the sql notification won't run on a "Job Failed" in the Job "flow" section, but email notifications will, same for task error. Do you understand? Thanks.

But an SQL Notification works in another Job? It sounds like something is different in the Flow settings?

---