September 4, 2018 at 11:15 pm
I want to create SQL Server Alert which should run a policy(created in maintenance) which checks whether indexes are clustered or not.
Is it possible to implement it? In a job step there is field to write TSQL but I don't know the TSQL to evaluate a policy.
Thanks for your time.
September 5, 2018 at 8:16 am
elea.grig - Tuesday, September 4, 2018 11:15 PMI want to create SQL Server Alert which should run a policy(created in maintenance) which checks whether indexes are clustered or not.
Is it possible to implement it? In a job step there is field to write TSQL but I don't know the TSQL to evaluate a policy.
Thanks for your time.
You want a policy that fails if any of the indexes are not clustered? That doesn't make a lot of sense - what is it you are looking for? What are you trying to accomplish with a policy for this?
Sue
September 5, 2018 at 8:54 am
Sue_H - Wednesday, September 5, 2018 8:16 AMelea.grig - Tuesday, September 4, 2018 11:15 PMI want to create SQL Server Alert which should run a policy(created in maintenance) which checks whether indexes are clustered or not.
Is it possible to implement it? In a job step there is field to write TSQL but I don't know the TSQL to evaluate a policy.
Thanks for your time.You want a policy that fails if any of the indexes are not clustered? That doesn't make a lot of sense - what is it you are looking for? What are you trying to accomplish with a policy for this?
Sue
Still not real clear but just thought maybe this is what you are looking for:
SQL Server Policy Base Management Has Clustered Index Condition
Alerts don't run policies though. Policies have evaluation modes - that might be what you are referring to.
Sue
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply