Hello,

We have VisualCron 8.3.4 installed on a server and SQL Server 2016 installed on another server.
We need to run SSIS packages from VisualCron. Because SSIS is not installed on the VisualCron server, we created a SQL Agent Job on the SQL Server that runs the SSIS package.

In VisualCron, I created the SQL task that runs the SQL Agent job.
When I run it from VisualCron, I see on the SQL Server that the job is being triggered and succeed but the VisualCron task is still running.

That looks a lot like the other issue we have with Oracle tasks that keeps running if longer than 1 hour. But in this case, it is on another server and it does it even if the task last a few seconds.

Thank you!

This is the connection string I use:
Data Source=Server\Instance;Integrated Security=SSPI;

I found the problem. When I look in the SQL Activity Monitor, I see the VisualCron connection is monitoring the job with this query:

(@JobId uniqueidentifier,@InstanceId int)SELECT message,run_status FROM [msdb].[dbo].[sysjobhistory] jh WHERE jh.job_id = @JobId AND step_name IN ('(Job outcome)','(Auftragsergebnis)') AND jh.instance_id > @InstanceId

I see it would work for SQL installed in English or Germanic. The SQL Server is installed in French so the step_name is '(Sortie du travail)'.

I think it should work better with step_id=0 instead of step_name IN ( ... ).

I found the problem. When I look in the SQL Activity Monitor, I see the VisualCron connection is monitoring the job with this query:

(@JobId uniqueidentifier,@InstanceId int)SELECT message,run_status FROM [msdb].[dbo].[sysjobhistory] jh WHERE jh.job_id = @JobId AND step_name IN ('(Job outcome)','(Auftragsergebnis)') AND jh.instance_id > @InstanceId

I see it would work for SQL installed in English or Germanic. The SQL Server is installed in French so the step_name is '(Sortie du travail)'.

I think it should work better with step_id=0 instead of step_name IN ( ... ).

Great, thanks for the feedback. Please test this build:

https://www.visualcron.c....aspx?g=posts&t=7901 

---

Hello,

I just tested 8.3.5 but I have the same issue, the query is still the same.

(@JobId uniqueidentifier,@InstanceId int)SELECT message,run_status FROM [msdb].[dbo].[sysjobhistory] jh WHERE jh.job_id = @JobId AND step_name IN ('(Job outcome)','(Auftragsergebnis)') AND jh.instance_id > @InstanceId

Hello,

I just tested 8.3.5 but I have the same issue, the query is still the same.

(@JobId uniqueidentifier,@InstanceId int)SELECT message,run_status FROM [msdb].[dbo].[sysjobhistory] jh WHERE jh.job_id = @JobId AND step_name IN ('(Job outcome)','(Auftragsergebnis)') AND jh.instance_id > @InstanceId

Please try again - apparently we missed one place:

https://www.visualcron.c....aspx?g=posts&t=7901 

---

Hello Henrik,

That works fine now.

Thank you!

Hello Henrik,

That works fine now.

Thank you!

Great, thanks for the report and details!

---