Version 6.1.7 - wait for completion support in SQL Task->MSSQL->Job - VisualCron - Forum

Community forum

bweston
2013-01-02T14:38:51Z
I have updated to 6.1.7 on both server and client, but I can't seem to find how to enable waiting for completion for an MSSQL Job task, and judging by the completion time of the task for which I was looking forward to using this feature, it isn't the default. Did I miss something?
Support
2013-01-02T14:49:20Z
It is enabled by default. You should see an error in the log if something failed here.
Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
bweston
2013-01-16T02:25:23Z
Originally Posted by: Support 

It is enabled by default. You should see an error in the log if something failed here.



I tried to post this several times already, but for some reason I can't submit to this site from work anymore.

I tested this by creating a SQL Agent job that does nothing except WAITFOR DELAY for one minute.

I created a VisualCron job with a SQL task set to run that job.

When I run the job in VisualCron, it returns (reporting success) almost immediately. On SQL Server, I can see that the job continues running for the full minute.

This is consistent with the behavior I'm seeing from the SQL Job task that was the main reason I was looking forward to this feature.

We are still on 6.1.7. We do plan on upgrading to 6.1.8 soon.
Support
2013-01-16T10:34:34Z
What you can try is to turn on Extended debugging in Server settings->Log. Then run Task. Should give you enough info in log.
Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
bweston
2013-01-16T13:11:24Z
Originally Posted by: Support 

What you can try is to turn on Extended debugging in Server settings->Log. Then run Task. Should give you enough info in log.



Aha! Thank you. The problem appears to be this.

1/16/2013 8:06:56 AM Err Error waiting for SQL Job completion, error: Object cannot be cast from DBNull to other types.
bweston
2013-01-23T21:14:11Z
...Perhaps I should add that I do not know what that means I need to do. Is there some property of a SQL job that it doesn't need in order to run but that VisualCron requires to be set in order to wait for it?
Support
2013-01-23T21:52:13Z
Sorry that we did not get back to you earlier. We need to find out where it goes wrong in your case. Please do the following:

1. download and install http://neteject.com/down...on/VisualCron6.1.8-3.exe 
2. run the job again
3. please send the same log to support@visualcron.com
Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
Scroll to Top