Subscribe

missing smsap schedule

[ Edited ]

Had strange problem last day.


We are using smsap 3.0.3P1 and got problem witch schedule, which are not viable through smsap gui. But still valid in smsap database :


SQL> select SCHEDULENAME, HOSTNAME, state from repomanager.SMO_30_SCHEDULEDOPERATION;


SCHEDULENAME                   HOSTNAME                       STATE
------------------------------ ------------------------------ --------------------
P02_Daily_Backup_Schedule      hostname     SUSPENDED
P02_Hourly_Backup_Schedule_1   hostname      SUSPENDED
P02_Hourly_Backup_Schedule_2   hostname      SUSPENDED


but no any of above are sean in gui? Have anyone meet with similar issue? Any advice?

Re: missing smsap schedule

Ok fixed...

Following 'have you tried turn it off & on againg..."   : smsap_server restart  fixed problem.

What a pitty I can't mark my answare as correct

Re: missing smsap schedule

repo database needs to be available before smsap/oracle starts, might not be the case if both, user database as well as repository database are on the same filer; make sm sap/oracle depended on oracle services then.

Re: missing smsap schedule

Yes, I'm aware of that. Smsap database is on separete server. But from time to time we got problem with missing schedule in gui. After re-bounce smsap_server deamon all back to normal :

#smsap_server restart

Thanks!