Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

TSM ::: sp_deletesmobj example


I'm not able to delete oldest backup with sp_deletesmobj stored procedure... I'm sure that I'm wrong...

If I run with...

sp_deletesmobj "syb_tsm", "PRD"

OK, all object are deleted... but I would like to delete only older then 50 days


set @PIPPO = DATEADD(day, -50, GETDATE())

exec sp_deletesmobj "syb_tsm", "PRD", "*", "c:\obj.txt", "*", "*", @PIPPO

The system display e message like:

Could not execute statement.

The name 'DecĀ  7 2014 10:14PM' is not a valid identifier.

Sybase error code=203

Severity Level=16, State=3, Transaction State=0

Line 128

Have you got any idea?


Helpful Answer

Not what you were looking for? View more on this topic or Ask a question