Daily and weekly jobs failing

[knight_rider]

Hi All,

I have an issue where the daily and weekly jobs are failing on a customers site. It looks like it is failing on both when the purge alarm reports job.

Here is the log file from the failed weekly job:

[4/12/2015 1:48:06 AM] Scheduler: The job is started.
[4/12/2015 1:48:09 AM] Target:
[4/12/2015 1:48:09 AM] Target: Cleaning reports.
[4/12/2015 1:48:12 AM] Target: DBConnection::DBConnection java.sql.SQLException: JZ006: Caught IOException: java.net.ConnectException: Connection refused: connect
[4/12/2015 1:48:12 AM] Scheduler: Job failed -> next retry at 4/12/2015 2:03:12 AM.
[4/12/2015 2:03:14 AM] Scheduler: The job is started; retry #1.
[4/12/2015 2:03:16 AM] Target:
[4/12/2015 2:03:16 AM] Target: Cleaning reports.
[4/12/2015 2:03:19 AM] Target: DBConnection::DBConnection java.sql.SQLException: JZ006: Caught IOException: java.net.ConnectException: Connection refused: connect
[4/12/2015 2:03:19 AM] Scheduler: Job failed.

The log file for the daily job is an the same error.

Anyone able to offer any suggestions???

[cavagnaro]

Sql says refusing connection, can you test basic communication like port, connectivity, user, password?

[haroun]

Try to connect to sybase with credential to see if sqlserv is runing with those one