Script to know whether database backups are being done on SQL SERVER databases ??

Hi All,
I want to have a script which will let me know whether all the
databases in a SQL SERVER are being backed up.I tried using
sysjobs,sysjobhistory,etc on msdb,but am unbale to joing them to know
the databases for which they are being backedup.
TIA,
AKIf you're using maintenance plans, you can query like this:
SELECT TOP 10 *
FROM msdb.dbo.sysdbmaintplan_history
WHERE activity = 'Backup database'
Andre
"AkB" <anilkb@.gmail.com> wrote in message
news:47ce6498.0410191209.612cca5e@.posting.google.com...
> Hi All,
> I want to have a script which will let me know whether all the
> databases in a SQL SERVER are being backed up.I tried using
> sysjobs,sysjobhistory,etc on msdb,but am unbale to joing them to know
> the databases for which they are being backedup.
> TIA,
> AK