Wednesday, March 7, 2012

call database Maintenance plan from Sql Server Agent->Job

Hi There
can i call database Maintenance plan from Sql Server Agent->Job
what i'm trying to do
I've to truncated records on log table,
then shrink all databases
the call maintenance plan to take all database backup
Thanks
GaneshGanesh
http://www.karaszi.com/SQLServer/info_dont_shrink.asp
"Ganesh" <gsganesh@.yahoo.com> wrote in message
news:A9B19A8E-AE37-4B2B-A0C9-B800E6119472@.microsoft.com...
> Hi There
> can i call database Maintenance plan from Sql Server Agent->Job
> what i'm trying to do
> I've to truncated records on log table,
> then shrink all databases
> the call maintenance plan to take all database backup
> --
> Thanks
> Ganesh|||Probably the best advice the OP should follow, but probably not what he
wanted to hear. :)
ML
http://milambda.blogspot.com/|||Check out this. Let me know if this is what you were looking for.
http://www.dbazine.com/sql/sql-articles/cook10

No comments:

Post a Comment