I wanted to view the scheduled DTS jobs. So obvious way I thought was to do view it where I created. But for some reason, the schedule has been reset. So there is no way we can view the scheduled jobs of DTS here.
If you want to view these jobs, you have to access the SQL SERver Agent as these jobs are run by SQL SERVER Agent. So follow these steps to ciew your scheduled jobs on SQL server.
Go to SQL SERVER Enterprise Manager -- Management folder
Then click on SQL SERVER AGENT -- Jobs
Here you can see the job name status etc.
Subscribe to:
Post Comments (Atom)
Navigating the Data Science Seas: A Journey with Microsoft Fabric
Data science is a vast and exciting field, brimming with the potential to unlock valuable insights. But like any seafaring voyage, navigatin...
-
From the past 3 days I have been working on resolving merged and hidden cells issues when an SSRS reports is exported to excel. ... -
I was trying to build an SSIS package that one of my colleagues has created. The first error that was thrown was as below: Exception des... -
Today I was trying Node.js to connect to SQL Server, the connection to the sql server failed with the below error. name: 'ConnectionE...
No comments:
Post a Comment