Developer's Alley
TODO:
Have you ever wanted to get information on SQL Server Mainenance Plan job steps using T-SQL?
SOLUTION:
select * From msdb..sysjobs
NOTES:
There are no notes on this topic.
Problem is that this is not a Maintenance Plan listing, this is a SQL Agent Jobs listing. Although the Maintenance Plans run ultimately as Jobs, this listing of information does not dissociate between a distinct Job and a Maintenance Plan Job. Please revise this to show the correct syntax.
Very interesting post….really informative…..of all the blogs I have read on the same topic, this one is actually enlightening….I was longing to read such kind of informative write-ups from a very long time…good to know that such kind of posts are there to help ignorant and novice people.
Cancel reply to comment
Name* Required Please choose another name
E-mail*
Country [Not specified] Afghanistan Albania Algeria Angola Argentina Armenia Australia Austria Azerbaijan Bahrain Bangladesh Belarus Belgium Belize Bermuda Bolivarian Republic of Venezuela Bolivia Bosnia and Herzegovina Botswana Brazil Brunei Darussalam Bulgaria Cambodia Cameroon Canada Caribbean Chile China Colombia Congo [DRC] Costa Rica Croatia Czech Republic Denmark Dominican Republic Ecuador Egypt El Salvador Eritrea Estonia Ethiopia Faroe Islands Finland France Georgia Germany Greece Greenland Guatemala Guinea Haiti Honduras Hong Kong Hong Kong SAR Hungary Iceland India Indonesia Iran Iraq Ireland Israel Italy Ivory Coast Jamaica Japan Jordan Kazakhstan Kenya Korea Kuwait Kyrgyzstan Lao PDR Latin America Latvia Lebanon Libya Liechtenstein Lithuania Luxembourg Macao SAR Macedonia (Former Yugoslav Republic of Macedonia) Madagascar Malaysia Maldives Mali Malta Mexico Moldova Mongolia Montenegro Morocco Myanmar Nepal Netherlands New Zealand Nicaragua Nigeria Norway Oman Pakistan Panama Paraguay Peru Philippines Poland Portugal Principality of Monaco Puerto Rico Qatar Réunion Romania Russia Rwanda Saudi Arabia Senegal Serbia Serbia and Montenegro (Former) Singapore Slovakia Slovenia Somalia South Africa Spain Sri Lanka Sweden Switzerland Syria Taiwan Tajikistan Thailand Trinidad and Tobago Tunisia Turkey Turkmenistan U.A.E. Ukraine United Kingdom United States Uruguay Uzbekistan Vietnam Yemen Zimbabwe
Notify me when new comments are added
Get notified when a new post is published.