SQL Job Status 
Author Message
 SQL Job Status
SQL 7.0

I created a SQL job and scheduled to execute. It worked fine.
When I right click the job and select 'View Job History' , message "There is
no history information for this job"

In tab 'Step' of the job under 'Advance' , I checked 'Append output to step
history'.

How to configure this information to retain rather get deleted ??

Thx
Sh



Fri, 06 Jan 2006 16:38:07 GMT
 SQL Job Status

In Enterprise Manger, expand server, right click "SQL Server Agent", click
"properties", then click tab "Job System" and increase values in the job
history log section.


Quote:
> SQL 7.0

> I created a SQL job and scheduled to execute. It worked fine.
> When I right click the job and select 'View Job History' , message "There
is
> no history information for this job"

> In tab 'Step' of the job under 'Advance' , I checked 'Append output to
step
> history'.

> How to configure this information to retain rather get deleted ??

> Thx
> Sh



Fri, 06 Jan 2006 18:33:28 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Job status from within a job

2. Job Status for scheduled job

3. JOBS JOBS JOBS JOBS JOBS JOBS JOBS JOBS JOBS

4. Status of a SQL agent job

5. "Failed" Status on SQL Agent Job

6. Status of SQL Server Jobs

7. Current Job Status using SQL

8. status of sql server job

9. SQL Server Agent Job Status

10. bug? sql agent: job status = 7

11. Check Status of SQL Server Agent jobs using ASP

12. SQL-DMO Job Execution Status


 
Powered by phpBB® Forum Software