VisualCron task - SQL Job still running - VisualCron - Forum

Community forum

Etienne Lemire
2018-04-16T19:53:00Z
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!
Etienne Lemire
2018-04-16T19:54:33Z
This is the connection string I use:
Data Source=Server\Instance;Integrated Security=SSPI;
Etienne Lemire
2018-04-16T20:39:16Z
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 ( ... ).
Support
2018-04-17T06:28:02Z
Originally Posted by: Etienne Lemire 

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 
Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
Etienne Lemire
2018-04-17T14:40:34Z
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
Support
2018-04-17T16:22:50Z
Originally Posted by: Etienne Lemire 

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 
Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
Etienne Lemire
2018-04-17T16:52:04Z
Hello Henrik,

That works fine now.

Thank you!
Support
2018-04-17T16:52:35Z
Originally Posted by: Etienne Lemire 

Hello Henrik,

That works fine now.

Thank you!



Great, thanks for the report and details!

Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
Scroll to Top