We have almost 40 SQL Servers and we have deployed and running many SSIS Package jobs in each server.
Can you please tell me
1. How can we find how many jobs are deployed and enabled in each servers?.
2. Each enabled job total counts seperately (adding each enabled jobs counts from all the servers like Job A - 30 and Job B -20 like that)
Thanks a lot.
Why is this different from all of the other step by step guides? Because I make a living as a DBA and not as a writer and I lived through this experience.
Defining the name:
When I talk to people they say different names on this subject stuff l…
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables.
Make a table:
Update a specific column given a specific row using the UPDATE statement:
Remove a set of values using the DELETE s…