Please note that VisualCron support is not actively monitoring this community forum. Please use our contact page for contacting the VisualCron support directly.


GrahamG
2009-02-17T16:55:47Z
Hi,

I have a job with 3 tasks.

1) Stop a service.
2) Update the service software/configs - copies file to the service bin directory.
3) Restart service.

It is triggered by a simple trigger file in the source file directory.

However, if the service has already stopped for any reason, the job gets aborted with an unhandled exception error.

Is this by design or is there anyway to make it carry on with the job. I don't really want to create 2 jobs to do this as it then gets messy.

Any thoughts appreciated.

Thanks

Graham


Sponsor
Forum information
Support
2009-02-17T17:17:18Z
You mean that the Restart service returns error if the service is already stopped?
Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
GrahamG
2009-02-17T17:27:01Z

No, the "service stop request" on a stopped service (task 1) causes the error.


Graham

GrahamG
2009-02-17T18:02:47Z

Not sure if relevant, but this is on a remote server.

Graham
Support
2009-02-17T18:47:39Z
Ok, we have changed the behavior for the next version so it should not throw an error if it is already stopped. Thanks for reporting.
Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
shohn
2009-02-18T16:50:42Z
The start service command used to throw an error in version 4.9.40 if a service is already started.
Support
2009-02-18T16:52:42Z
Both these are fixed in version 5.0.0.
Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
shohn
2009-03-26T17:10:57Z
What if the service is already started. In the version I am running, if a service is already started, and an attempt is made to start the service then it returns an error, which should probably not be the case.
Support
2009-03-26T17:18:32Z
I am quite sure we fixed both. Which version are you running now?
Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
shohn
Support
2009-03-26T17:31:51Z
I am 99% sure that this is fixed as well.
Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
shohn
2009-03-30T15:56:05Z
I have a couple of tasks in a row.

This is the stderr from one of them which starts the sqlagent on remote system:

Unhandled exception in Task: Cannot start service SQLSERVERAGENT on computer 'server.local.domain.com'.



Then a bit later I run another task to execute a sql agent job which returns the output:

Job 'backup_cubes' started successfully.
1>

The agent is started somehow or another given that I am able to run a sql agent job.

This is SQL server 2005, Windows 2003 x64.
Support
2009-03-30T16:27:37Z
What is the exception? Normally the exception is stored in stderr or stdout column.

shohn wrote:

I have a couple of tasks in a row.

This is the stderr from one of them which starts the sqlagent on remote system:

Unhandled exception in Task: Cannot start service SQLSERVERAGENT on computer 'server.local.domain.com'.



Then a bit later I run another task to execute a sql agent job which returns the output:

Job 'backup_cubes' started successfully.
1>

The agent is started somehow or another given that I am able to run a sql agent job.

This is SQL server 2005, Windows 2003 x64.



Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
shohn
2009-03-30T17:10:24Z
The output says "No Output"

Stderr and Result contain:

Unhandled exception in Task: Cannot start service SQLSERVERAGENT on computer 'server.local.domain.com'.
Support
2009-03-30T17:26:48Z
Do you see any other error in the log?

shohn wrote:

The output says "No Output"

Stderr and Result contain:

Unhandled exception in Task: Cannot start service SQLSERVERAGENT on computer 'server.local.domain.com'.



Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
shohn
2009-03-30T18:45:36Z
3/30/2009 4:07:05 AM Debug Task (3115) was added to processlist: Start SQL Agent
3/30/2009 4:07:05 AM Info Task started: Start SQL Agent
3/30/2009 4:07:05 AM Debug Running SQL Notification: 'Job Start - job_stats table on egovern'
3/30/2009 4:07:05 AM Debug Running SysLog Notification: 'Syslog: Task Start'
3/30/2009 4:07:06 AM Err Unhandled exception in Task: Cannot start service SQLSERVERAGENT on computer 'server.local.domain.com'.
3/30/2009 4:07:06 AM Info Task completed: Start SQL Agent
3/30/2009 4:07:06 AM Debug Setting previous task in TaskProcessCompleted: Start SQL Agent (9206776d-c727-483f-baf7-e421b8a37996) in job: Internal_Backup_PRD_ALL_Cubes_Daily_Full
3/30/2009 4:07:06 AM Debug Process status - About to SendTaskProcess (3115)
3/30/2009 4:07:06 AM Debug Process status - About to RemoveTaskProcess (3115)
3/30/2009 4:07:06 AM Debug Task (3115) was removed from processlist: Start SQL Agent
3

See attached screenshot.
shohn attached the following image(s):
Support
2009-03-30T18:52:28Z
Did you try the latest version? Seems like you get the error because it is already running?
Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
shohn
2009-03-30T23:11:17Z
As stated at the beginning of this thread, we were on 4.9.40. If there has been a bug fix for this release or is this in the 5.x series?
Support
2009-03-31T10:18:41Z
Yes, this was fixed in version 5.0.0.

shohn wrote:

As stated at the beginning of this thread, we were on 4.9.40. If there has been a bug fix for this release or is this in the 5.x series?



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