Thursday, November 01, 2007

Viewing DTS scheduled jobs

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.

No comments:

How to download files from Microsoft Fabric Lakehouse ?

  Challenge : Yesterday I was trying to download a parquet file from the Microsoft Lakehouse on to my laptop.  So I was searching for the do...