October 5, 2012 at 9:29 am
Hi there,
I am trying to initiate a Netbackup task from a SQL Job using the following CmdExec code:
"C:\Program Files\VERITAS\NetBackup\bin\dbbackex.exe" -f "C:\Program Files\Veritas\NetBackup\DbExt\MsSql\<Filename.bch>" -p <profilename> -u <username> -pw <password> -s <server> -np
If I run it from a Command Prompt window it works fine, however if I copy the exact same code into a SQL Job and use the job type 'Operating System (CmdExec)' it fails to run. All I get in the Job History is:
"Executed as user: Domain\Username. The step did not generate any output. Process Exit Code 2. The step failed."
I have managed to get this to work on another almost identical server using the same accounts and everything but for some reason it won't run on the one I'm currently using.
Any suggestions? Anything that needs to be enabled on the server perhaps?
Thanks,
Matt
October 5, 2012 at 9:33 am
If you right click on SQL Server Agent in SSMS and then go to Properties -> Job System, is the box checked to use a non-admin proxy account?
October 8, 2012 at 2:45 am
No, it's actually greyed out (presumably because we don't have any)....although on the server it is working on it's also the same.
October 8, 2012 at 9:52 am
Just in case anyone is interested I managed to resolve this issue....
I simply added the account running SQL Agent to the local admin group on the server, then restarted the SQL Agent service 🙂
October 7, 2013 at 3:45 pm
Rather than giving the agent account administrative rights to the entire server, it might help if you read this.
http://fixunix.com/veritas-net-backup/481537-start-netbackup-sqlserveragent.html
SQL Agent needs rights to create temporary ODBC connections. So you modify the registry permssions and give the Agent Account full access to the Veritas folder.
September 25, 2015 at 3:21 pm
This worked for me. Thanks! I did know about the registry permissions mentioned in the comment below and that has worked for me in the past, but that didn't work this time, so I tried your fix and that did it. Thanks again.
September 25, 2015 at 11:04 pm
which fix are you referring to?
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply