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)
Databases and Data Visualisations Course for kids Week 1
As mentioned last week, I have started the Databases and Data Visualisations course for kids aged between 11 to 15 years yesterday. It was...
-
I needed to convert some vbscript to javascript as firefox doesn't support vbscript. I found this online tool very helpful Beware tha...
-
This morning I was trying to call a stored procedure and insert the results in a temp table using the following code -- create table #...
-
When I tried to access the report manager after a fresh installation of Sql Server Reporting Serivces 2016 using the url http://localhost/R...
No comments:
Post a Comment