Jobs - 2 questions

[sqlcasey]

Hi,

ver 2005

1.) What does it mean when it shows a job executed successfully at such and such time, but there is no history under "view history" ?

2.) Is there a reason that an "EXEC (mySQLStmt)" would not run from a stored procedure that is called from a job?

That is, if I run the "EXEC (mySQLStmt)" from mgmt studio, it works fine, but if it tries to run from the job (which calls an sp that contains this line) it doesn't execute (but no error msgs).

Thanks much

 

[timscronin]

#2 Permissions could be an issue. Are you using the service or sa to run this job?

 

[ptheriault]

how many steps in the job for question 1.
Select properties for SQL Server Agent, select the History page. How much history are you saving? What is the Max job rows per job.

- Paul
- If at first you don't succeed, find out if the loser gets anything.