Dear All,
Had below queries:
1. Is there a way to know whether the scheduled execution package is running or not either from the backend or any other way?
2. If the project repository is on the server A and the same server has Jet scheduler service and there is another Development machine B which uses the project repository of server A but also has JDM scheduler installed on it. In this scenario if the package is schedule on the Machine B will it use the scheduler of machine B or Server A?
Date
Votes
2 comments
-
Jet Reports Historic Posts Official comment You can view if a package is running or not by right-clicking the package in the JDM and selecting "View Execution History Log" it will state "Unknown" in the succeeded column.
-
Jet Reports Historic Posts You can view if a package is running or not by right-clicking the package in the JDM and selecting "View Execution History Log" it will state "Unknown" in the succeeded column.
Unfortunately, if a package fails, the history will not necessarily update to say 'Fail', or tell you much if the package is doing much.
There are some aftermarket tools to monitor SQL processes (I'm not sure if I'm allowed to name names), but it may be good to invest in products if you are doing lots of SQL work in your business.
As for what you probably already have, you can use the Windows Resource Monitor to check out network, disk, and memory performance to get a marginal idea if your server is doing work. I also use the Activity Monitor in Microsoft SQL Server Management Studio to check on active processes that are running against the database.
Please sign in to leave a comment.