{"tag":{"id":"6319f6b06b34d71380dae799","name":"SQL Server Agent","logo":null,"slug":"sql-server-agent","tagline":null,"__typename":"Tag"},"publication":{"__typename":"Publication","id":"61df2a3544f1964f4fa7fba7","url":"https://blog.rajanand.org","canonicalURL":"https://blog.rajanand.org","urlPattern":"SIMPLE","title":"Rajanand's Blog","displayTitle":"blog.rajanand.org","hasBadges":true,"descriptionSEO":"I am a Business intelligence lead with over a decade of experience in building DW/BI solutions. I am a Microsoft Certified Solutions Expert in Data management & analytics and trainer.","publicMembers":{"totalDocuments":1,"__typename":"PublicationMemberConnection"},"about":{"html":"

I'm a Business Intelligence Developer with over a decade of experience in design and development of databases, data warehouse, ETL, business intelligence reports and data visualization/analytics.

\n","text":"I'm a Business Intelligence Developer with over a decade of experience in design and development of databases, data warehouse, ETL, business intelligence reports and data visualization/analytics.\n","__typename":"Content"},"features":{"proTeam":{"isEnabled":false,"__typename":"ProTeamFeature"},"newsletter":{"isEnabled":true,"__typename":"NewsletterFeature"},"viewCount":{"isEnabled":true,"__typename":"ViewCountFeature"},"readTime":{"isEnabled":true,"__typename":"ReadTimeFeature"},"textSelectionSharer":{"isEnabled":false,"__typename":"TextSelectionSharerFeature"},"customCSS":{"isEnabled":true,"published":{"__typename":"CustomCSS","homeMinified":null,"postMinified":"@import url(\"https://fonts.googleapis.com/css?family=Space+Grotesk&display=swap\") .blog-content-area{font-family:'Space Grotesk',serif}","staticMinified":null},"draft":{"__typename":"CustomCSS","homeMinified":null,"postMinified":"@import url(\"https://fonts.googleapis.com/css?family=Space+Grotesk&display=swap\") .blog-content-area{font-family:'Space Grotesk',serif}","staticMinified":null},"__typename":"CustomCSSFeature"},"gptBotCrawling":{"__typename":"GPTBotCrawlingFeature","isEnabled":false},"__typename":"PublicationFeatures"},"metaTags":"\n\n\n\n $\"Clicky\"$ \n\n\n\n\n\n\n","ogMetaData":{"image":null,"__typename":"OpenGraphMetaData"},"author":{"__typename":"User","id":"576c0b8e956de5c9316890d0","name":"Rajanand Ilangovan","username":"Rajanand","profilePicture":"https://cdn.hashnode.com/res/hashnode/image/upload/v1642238850976/wNjS4RJ-P.png"},"preferences":{"__typename":"Preferences","logo":null,"darkMode":{"__typename":"DarkModePreferences","logo":null,"enabled":false},"navbarItems":[{"__typename":"PublicationNavbarItem","id":"63dbb6cc787b1b79bedc1e02","label":"web","url":"https://link.rajanand.org/home","type":"link","series":null,"page":null},{"__typename":"PublicationNavbarItem","id":"61dfbe748a0e7c6db7fba500","label":"contact","url":"https://link.rajanand.org/bio","type":"link","series":null,"page":null},{"__typename":"PublicationNavbarItem","id":"62e9ffbd92b7fd0a78c34f7e","label":"archive","url":"https://blog.rajanand.org/archive","type":"link","series":null,"page":null},{"__typename":"PublicationNavbarItem","id":"625465d2b32ddd968bbe9cb4","label":"download","url":"https://link.rajanand.org/download","type":"link","series":null,"page":null}],"enabledPages":{"__typename":"PagesPreferences","badges":false,"newsletter":true,"members":true},"layout":"stacked","disableFooterBranding":false,"isSubscriptionModalDisabled":false},"favicon":null,"headerColor":"#48639C","integrations":{"fbPixelID":"1253148365193934","fathomSiteID":"","fathomCustomDomainEnabled":false,"fathomCustomDomain":"","hotjarSiteID":"2780996","matomoSiteID":null,"matomoURL":"","gaTrackingID":"G-41YJ2WRT3K","gTagManagerID":null,"plausibleAnalyticsEnabled":null,"wmPaymentPointer":"","koalaPublicKey":null,"msClarityID":null,"__typename":"PublicationIntegrations"},"imprintV2":{"__typename":"Content","html":"

Download Scenario based SQL data challenges

\n"},"postsCount":{"totalDocuments":76,"__typename":"PublicationPostConnection"},"isTeam":true,"links":{"twitter":"https://twitter.com/iRajanand","instagram":null,"github":"https://github.com/Rajanand","website":"https://www.rajanand.org","hashnode":null,"youtube":"https://www.youtube.com/@iRajanand","dailydev":null,"linkedin":"https://linkedin.com/in/irajanand","mastodon":null,"facebook":null,"bluesky":null,"__typename":"PublicationLinks"},"domainInfo":{"__typename":"DomainInfo","hashnodeSubdomain":"rajanand","domain":{"__typename":"DomainStatus","host":"blog.rajanand.org","ready":true},"wwwPrefixedDomain":null},"redirectionRules":[{"source":"/youtube","destination":"https://youtube.com/@iRajanand","type":"PERMANENT","__typename":"RedirectionRule"},{"source":"/certifications","destination":"https://www.rajanand.org/certifications/","type":"PERMANENT","__typename":"RedirectionRule"},{"source":"/linkedin","destination":"http://linkedin.com/in/irajanand","type":"PERMANENT","__typename":"RedirectionRule"},{"source":"/contact","destination":"https://rajanand.org/contact","type":"PERMANENT","__typename":"RedirectionRule"}],"totalRecommendedPublications":0,"sponsorship":{"content":{"html":"

I am a Microsoft certified SQL Server and Power BI developer. I write about SQL Server, Power BI, Azure data factory and Azure synapse analytics. If you like the article and if it has helped you in any way, you may consider sponsoring this blog. Thanks for your support.

\n","markdown":"I am a Microsoft certified SQL Server and Power BI developer. I write about SQL Server, Power BI, Azure data factory and Azure synapse analytics. If you like the article and if it has helped you in any way, you may consider sponsoring this blog. Thanks for your support. \n\n","__typename":"Content"},"stripe":{"connected":true,"accountId":"acct_1Kjem7SCbsfxEzP7","country":"IN","__typename":"StripeConfiguration"},"__typename":"PublicationSponsorship"},"allowContributorEdits":true,"posts":{"edges":[{"node":{"__typename":"Post","id":"641ab10460decf217f83a74c","title":"SSIS Error: Failed to decrypt protected XML node \"DTS:Password\" with error 0x8009000B \"Key not valid for use in specified state.","slug":"ssis-error-failed-to-decrypt-protected-xml-node-dtspassword-with-error-0x8009000b-key-not-valid-for-use-in-specified-state","publishedAt":"2023-03-21T07:38:14.000Z","cuid":"clfjdkzfu00060ajwbmv4078a","url":"https://blog.rajanand.org/ssis-error-failed-to-decrypt-protected-xml-node-dtspassword-with-error-0x8009000b-key-not-valid-for-use-in-specified-state","subtitle":"You may not be authorized to access this information. This error occurs when there is a cryptographic error. Verify that the correct key is available.","brief":"Problem:\nWe have created an SSIS package to load the data from a database in one server to another server. When tested in the local machine, it executed and data has been transferred as expected. But when we tried executing it through SQL Server Agen...","readTimeInMinutes":3,"views":2769,"author":{"__typename":"User","id":"576c0b8e956de5c9316890d0","username":"Rajanand","name":"Rajanand Ilangovan","profilePicture":"https://cdn.hashnode.com/res/hashnode/image/upload/v1642238850976/wNjS4RJ-P.png","followersCount":31},"coverImage":null},"cursor":"NjQxYWIxMDQ2MGRlY2YyMTdmODNhNzRjXzIwMjMtMDMtMjFUMDc6Mzg6MTQuMDAwWg==","__typename":"PostEdge"},{"node":{"__typename":"Post","id":"63d9736161e2b41f53a4d55f","title":"SSIS Error: Unable to load the package as XML because of package does not have a valid XML format.","slug":"ssis-error-unable-to-load-the-package-as-xml-because-of-package-does-not-have-a-valid-xml-format-access-is-denied","publishedAt":"2023-01-31T20:00:33.572Z","cuid":"cldknzmsk000109mb9k1p0fgk","url":"https://blog.rajanand.org/ssis-error-unable-to-load-the-package-as-xml-because-of-package-does-not-have-a-valid-xml-format-access-is-denied","subtitle":"Failed to open package file \"\\\\sharepath\\ssis\\package.dtsx\" due to error 0x80070005 \"Access is denied.\".","brief":"Problem:\nI was trying to execute the SSIS package through SQL Server Agent and got the error below.\n\nError Message :Executed as user: NT Service\\SQLSERVERAGENT.Microsoft (R) SQL Server Execute Package Utility Version 15.0.2000.5 for 64-bit Copyright ...","readTimeInMinutes":2,"views":4598,"author":{"__typename":"User","id":"576c0b8e956de5c9316890d0","username":"Rajanand","name":"Rajanand Ilangovan","profilePicture":"https://cdn.hashnode.com/res/hashnode/image/upload/v1642238850976/wNjS4RJ-P.png","followersCount":31},"coverImage":null},"cursor":"NjNkOTczNjE2MWUyYjQxZjUzYTRkNTVmXzIwMjMtMDEtMzFUMjA6MDA6MzMuNTcyWg==","__typename":"PostEdge"},{"node":{"__typename":"Post","id":"6319f6af6b34d71380dae798","title":"How to find a SQL Server agent jobs last executed and next scheduled date time?","slug":"how-to-find-a-sql-server-agent-jobs-last-executed-and-next-scheduled-date-time","publishedAt":"2022-09-08T14:05:35.560Z","cuid":"cl7t4gms007f5cxnvgpbv11yj","url":"https://blog.rajanand.org/how-to-find-a-sql-server-agent-jobs-last-executed-and-next-scheduled-date-time","subtitle":"","brief":"You can execute the below query to get the list of SQL Server agents jobs and when it was last executed and time it took to complete the job and when it is scheduled to run next.\nUSE msdb;\n\n-- List out all the SQL agent job in that server with detail...","readTimeInMinutes":2,"views":568,"author":{"__typename":"User","id":"576c0b8e956de5c9316890d0","username":"Rajanand","name":"Rajanand Ilangovan","profilePicture":"https://cdn.hashnode.com/res/hashnode/image/upload/v1642238850976/wNjS4RJ-P.png","followersCount":31},"coverImage":null},"cursor":"NjMxOWY2YWY2YjM0ZDcxMzgwZGFlNzk4XzIwMjItMDktMDhUMTQ6MDU6MzUuNTYwWg==","__typename":"PostEdge"}],"pageInfo":{"endCursor":"NjMxOWY2YWY2YjM0ZDcxMzgwZGFlNzk4XzIwMjItMDktMDhUMTQ6MDU6MzUuNTYwWg==","hasNextPage":false,"__typename":"PageInfo"},"__typename":"PublicationPostConnection"}}}

SQL Server Agent

SSIS Error: Failed to decrypt protected XML node "DTS:Password" with error 0x8009000B "Key not valid for use in specified state.

SSIS Error: Unable to load the package as XML because of package does not have a valid XML format.

How to find a SQL Server agent jobs last executed and next scheduled date time?