topic Re: missing smsap schedule in Data Protection

missing smsap schedule

lukasz_borek — Thu, 05 Jun 2025 06:59:08 GMT

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

lukasz_borek — Mon, 28 Feb 2011 14:53:53 GMT

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

thomas_glodde — Mon, 28 Feb 2011 17:13:14 GMT

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

lukasz_borek — Fri, 04 Mar 2011 08:18:48 GMT

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!