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)
Step By Step Guide to resolve SQL server connection issues when connecting from R Studio
Yesterday I tried using a couple of RevolveScaleR functions -- RxSqlServerData and RxImport.in Rstudio. These are my learnings as part of ...
-
I needed to convert some vbscript to javascript as firefox doesn't support vbscript. I found this online tool very helpful Beware tha...
-
I have been in hibernation for too long now. I have changed jobs and now hjaving an opportunity to work on SAS code after nearly 11 years. ...
-
The following features cannot be saved in macro-free workbooks VB Project To save a file with these features, click no, and then choose ...
No comments:
Post a Comment