Failed Steps of all Jobs and Disabled steps of all Jobs
-
Hi All, I want some help in getting all the steps which are either disabled or failed along with their job information of SQL Server, any help is going to be very helpful. Thanks in advance.
Thanks, Abdul Aleem "There is already enough hatred in the world lets spread love, compassion and affection."
-
Hi All, I want some help in getting all the steps which are either disabled or failed along with their job information of SQL Server, any help is going to be very helpful. Thanks in advance.
Thanks, Abdul Aleem "There is already enough hatred in the world lets spread love, compassion and affection."
indian143 wrote:
getting all the steps which are either disabled or failed along with their job information of SQL Server,
Get how? You can go look at them through the UI. Do you want sql to query for them? C# to run a report? Not sure what you want.
There are two kinds of people in the world: those who can extrapolate from incomplete data. There are only 10 types of people in the world, those who understand binary and those who don't.
-
indian143 wrote:
getting all the steps which are either disabled or failed along with their job information of SQL Server,
Get how? You can go look at them through the UI. Do you want sql to query for them? C# to run a report? Not sure what you want.
There are two kinds of people in the world: those who can extrapolate from incomplete data. There are only 10 types of people in the world, those who understand binary and those who don't.
Hi, I need to get all the Packages that are run either by using Job or without using the Jobs, I need the statuses of those Packages, whether they are failed or success. This is because I have a console application that's executing all the Packages one after the other, but if the Packages failed internally we are not informed of that, so I want to go ahead and check status of the Package after execution using query and find out what has happened. Any help would be greatly helpful. Thanks in advance. I want to get all the packages that are executed either by Job or without using the Job on a database. Thanks, Abdul Aleem "There is already enough hatred in the world lets spread love, compassion and affection."