Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

cmdexec step running and not doing anything Expand / Collapse
Author
Message
Posted Thursday, August 2, 2007 9:18 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, December 3, 2013 6:04 AM
Points: 305, Visits: 381

Hi Rudy,

We are capturing the output, unfortunately the log file is empty and the time stamp of the file is not changing, which makes be beleive that BAT file is not getting executed at all.

In some  case the BAT file is been called from DTS package. Package log shows the step executed successfully  and time taken by job is 0 sec.

Will change BAT to CMD for couple of jobs and will see how they behave as compared to BAT files.

Thanks

Deepak




Post #387446
Posted Friday, August 3, 2007 8:50 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: 2 days ago @ 6:55 AM
Points: 5,989, Visits: 12,927

I have seen simialar problems with sqlmaint and it is due to something happening to the .dll in memory, thats why restart of agent is re-setting it.

Possible options:

server reboot

copy the DLL over from another server thats ok

upgrade to SP4 could help you if this .dll is replaced by the upgrade



---------------------------------------------------------------------

Post #387802
Posted Tuesday, October 7, 2008 7:42 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, December 3, 2013 6:04 AM
Points: 305, Visits: 381
Finally narrowed down the issue. The cause is PGP encryption. When the BAT file which encrypts or decrypts data fails. It corrupts Agents Command Shell.

How to prevent it ?

Deepak




Post #581791
Posted Thursday, April 11, 2013 4:35 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Yesterday @ 11:40 PM
Points: 1,522, Visits: 2,551
.. Is the problem solved ?
Post #1441178
Posted Friday, April 12, 2013 3:02 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, December 3, 2013 6:04 AM
Points: 305, Visits: 381
Problem was not resolved , was living with it but found a way to get notified when jobs executes without actually running the BAT file.
Schedule a job which has 4/5 step, each step calls a BAT File directly or indirectly like from SSIS pkg or SP which uses xp_cmdshell or CMDEXEC. When bat/ssis/sp runs, it inserts a record in a table. Last step of the job checks if it has 4/5 records in the table , which indicates bat/ssis/sp go executed successfully else an email is sent to support team to look into the issue.

That was no the best solution but support team gets the msg to check and take necessary action.

Deepak



Post #1441613
Posted Friday, April 12, 2013 7:54 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Today @ 12:36 AM
Points: 36,995, Visits: 31,524
dkhattar (10/7/2008)
Finally narrowed down the issue. The cause is PGP encryption. When the BAT file which encrypts or decrypts data fails. It corrupts Agents Command Shell.

How to prevent it ?

Deepak



Fix the batch file?


--Jeff Moden
"RBAR is pronounced "ree-bar" and is a "Modenism" for "Row-By-Agonizing-Row".

First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."

(play on words) "Just because you CAN do something in T-SQL, doesn't mean you SHOULDN'T." --22 Aug 2013

Helpful Links:
How to post code problems
How to post performance problems
Post #1441708
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse