Job monitor for SQLServer

Any recommendations for software that provides a nice end-user
interface to records of jobs run in SQLServer, hopefully with a
real-time updating as jobs run as well?
Thanks.
JoshHi
You may want to look at http://www.idera.com/Products/SQLschedule/
John
"jxstern" wrote:
> Any recommendations for software that provides a nice end-user
> interface to records of jobs run in SQLServer, hopefully with a
> real-time updating as jobs run as well?
> Thanks.
> Josh
>

Job monitor for SQLServer

Any recommendations for software that provides a nice end-user
interface to records of jobs run in SQLServer, hopefully with a
real-time updating as jobs run as well?
Thanks.
JoshHi
You may want to look at http://www.idera.com/Products/SQLschedule/
John
"jxstern" wrote:

> Any recommendations for software that provides a nice end-user
> interface to records of jobs run in SQLServer, hopefully with a
> real-time updating as jobs run as well?
> Thanks.
> Josh
>

Job Activity Monitor

Is there any way to modify the layout of the Job Activity Monitor?

After I resize columns and/or the size of the window, when I close the window it does not save.

I assume this is a "feature". Any plans on fixing this?

Thanks!!!

I agree, you open the Job activity monitor, size the screen exactly how you like it, widen the left pane so you can see the job names in full, pull up the splitter so you can see more of the history details and less of the job runs, and then you close the window and lose it all and have to start again. Very very annoying.|||

No, this is not possible. This would be a good suggestion to file on Microsoft Connect: http://connect.microsoft.com/SQLServer/Feedback/.

Paul A. Mestemaker II
Program Manager
Microsoft SQL Server Manageability
http://blogs.msdn.com/sqlrem/

Job Activity Monitor

Hi,

I have a problem with Job Activity Monitor.

I have a SSIS which copies data from a table to a flat file. The connection string of this file is variable and the file is reused if not exists and is created if exists.

When I run the SSIS manually from my microsoft visual studio it works properly. However, when I run this SSIS from the Job Activity Monitor, I get the following error:

Message
Executed as user: REDCAM\adminsql2k5. Microsoft (R) SQL Server Execute Package Utility Version 9.00.3042.00 for 64-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 8:41:10 AM Error: 2007-09-10 08:48:04.99 Code: 0xC020200E Source: Crear Historico Historico [1] Description: Cannot open the datafile "\\srvnfile\HISTORICOS\CAJEROS\OFI3210C01\OFI3210C01_2007-7X.txt". End Error Error: 2007-09-10 08:48:04.99 Code: 0xC004701A Source: Crear Historico DTS.Pipeline Description: component "Historico" (1) failed the pre-execute phase and returned error code 0xC020200E. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 8:41:10 AM Finished: 8:48:53 AM Elapsed: 462.234 seconds. The package execution failed. The step failed.

Any idea?

Thanks.

Does the SQL Server service account have access to \\srvnfile\HISTORICOS?|||

Yes the SQL Server service account have access to \\srvnfile\HISTORICOS.

|||

Did you find the resolution to this issue?

|||Had the same problem - found this ans in sql server central.

Are you running SQL Server agent using a local account on the SQL box? If so, you'll have problems copying the file out to a network share. If this is the case, try restarting SQL Server Agent using a domain account that has write access to that share. (Tim)

That wasn't my problem. I used a mapped drive. (my perspective) Don't do that.

Job Activity Monitor

Is there any way to modify the layout of the Job Activity Monitor?

After I resize columns and/or the size of the window, when I close the window it does not save.

I assume this is a "feature". Any plans on fixing this?

Thanks!!!

I agree, you open the Job activity monitor, size the screen exactly how you like it, widen the left pane so you can see the job names in full, pull up the splitter so you can see more of the history details and less of the job runs, and then you close the window and lose it all and have to start again. Very very annoying.|||

No, this is not possible. This would be a good suggestion to file on Microsoft Connect: http://connect.microsoft.com/SQLServer/Feedback/.

Paul A. Mestemaker II
Program Manager
Microsoft SQL Server Manageability
http://blogs.msdn.com/sqlrem/

Job Activity Monitor

Hi,

I have a problem with Job Activity Monitor.

I have a SSIS which copies data from a table to a flat file. The connection string of this file is variable and the file is reused if not exists and is created if exists.

When I run the SSIS manually from my microsoft visual studio it works properly. However, when I run this SSIS from the Job Activity Monitor, I get the following error:

Message
Executed as user: REDCAM\adminsql2k5. Microsoft (R) SQL Server Execute Package Utility Version 9.00.3042.00 for 64-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 8:41:10 AM Error: 2007-09-10 08:48:04.99 Code: 0xC020200E Source: Crear Historico Historico [1] Description: Cannot open the datafile "\\srvnfile\HISTORICOS\CAJEROS\OFI3210C01\OFI3210C01_2007-7X.txt". End Error Error: 2007-09-10 08:48:04.99 Code: 0xC004701A Source: Crear Historico DTS.Pipeline Description: component "Historico" (1) failed the pre-execute phase and returned error code 0xC020200E. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 8:41:10 AM Finished: 8:48:53 AM Elapsed: 462.234 seconds. The package execution failed. The step failed.

Any idea?

Thanks.

Does the SQL Server service account have access to \\srvnfile\HISTORICOS?|||

Yes the SQL Server service account have access to \\srvnfile\HISTORICOS.

|||

Did you find the resolution to this issue?