English 中文(简体)
How to get a week s view history of the job i.e running from Autosys Job Schedular?
原标题:

SCENARIO:

Previously Jobs are scheduled to run from SQL Server.
In the SQL Server database the jobs ran as per their start times mentioned.
All the operations such as stopping the running job,starting the job are done by right clicking on the job.

View history for the job (status,starttime and endtime of the job) is done by right clicking the job and selecting view history.


By doing above thing we used to get details of entire week.


CHANGE IMPLEMENTED


The jobs running in the SQL Server database are now triggered from Autosys Console.
operations like starting the job,stopping the job are now done through Autosys.
Controlling job behaviour is done through Autosys.


PROBLEM

Could not get the view history of the job for entire week.
If we go for view history of any one particular job in the autosys console only the before day job execution details are given(status,start and end time) are given.

Is there any way in autosys job schedular console to get the job history of any particular job for the entire week?

Please help.

最佳回答

Check out JAWS from http://www.termalabs.com. It will provide an answer to your question and a whole lot more for your AutoSys environment.

问题回答

暂无回答




相关问题
SQL Server database is not visible

I have installed ASP.NET application with database on our server. ASP.NET application created database using connection string below. The problem is that I do not see database in SQL Server Management ...

Most efficient way to store number 11.111 in SQL Server

What datatype is the most efficient to store a number such as 11.111. The numbers will have up 2 digits before the point and up to three after. Currently the column is a bigint , I am guessing that ...

表格和数据表

是否需要在提瓜表之后更新表格统计数据,还是自动更新?

Inconsistent Generate Change Script

I add a column of type tinyint and being set to not allow nulls in a table and generate the change scripts. The table has data in it at this time. The script has code that creates a temp table and ...

Performance of Sql subqueriesfunctions

I am currently working on a particularly complex use-case. Simplifying below :) First, a client record has a many-to-one relationship with a collection of services, that is, a single client may have ...

selecting one value out of an xml column

I have a particularly troublesome xml column to query data from. The schema is fixed by the Quebec Ministry of Revenue so "it is what it is" The important part of the query looks like this: with ...

Selecting records during recursive stored procedure

I ve got a content management system that contains a hierarchical structure of categories, with sub-categories subject to different ordering options at each level. Currently, that s retrieved by a (...

热门标签