I have got simple question regarding ASE backup server.
I know that you can check it manually in error log, but he needs sp.
Our CT wants to monitor if backup server is up and down. For this purpose needs any stored procedure which returns 2 values 1 when it is up and 0 when it is down.
Is there any stored procedure within ASE which returns actual status of backup server?
Typically there are 2 things you can do -
1st is to perform a dump of a tiny database - e.g. model. This will take practically no time at all, and you can verify backupserver is up depending on the dump success/failure (@@error). You can code the backup in a sproc and return an appropriate status.
2nd is outside ASE (not what you asked, I know but...) where you can use isql to login to the backupserver (username and password don't matter) and the return code ($?) of isql tells you whether it can login or not. Perhaps you can code this as an SP througf XP Server if that's an option?
Other than that, I can't think of an SP you can use.
Hope that helps,