Need to run sql server package after job(loading) done

[prasson_ibm]

Hi,
I am connecting to SQL Server using ODBC connection and i have requirement where i need to call package after job completes.

Code: Select all

EXEC msdb.dbo.sp_start_job @job_name = 'app.GetVisionCasaDailyExtract';

My question is can i run this in Stored Proc stage if not then which stage should i use to trigger this.

[stephan.zahariev]

Hi,

You can create a sequence to invoke the job and afterwards use the "Execute Command" to run the stored procedure using the sqlcmd command.

Alternatively you can create after job subroutine to invoke the same stored procedure using the sqlcmd.

My personal preference goes to the first solution.

[prasson_ibm]

Hi,
Can you please tell me the full syntex to connect to seqserver from unix command prompt using sqlcmd.
When i am running this command it got failed.

Code: Select all

dsadm@ait-etl01dev:/inboundetl/dev $ sqlcmd
ksh: sqlcmd:  not found.

[prasson_ibm]

Hi,

Can not i call it in stored procedure stage.

[stephan.zahariev]

Sorry, did not noticed that you are running the job under Unix. The sqlcmd is a windows command.

Have no experience accessing the SQL Server from the Unix shell but this could work: http://www.sqsh.org/

[chulett]

Can not i call it in stored procedure stage.

I would certainly think so, yes.

[prasson_ibm]

Hi Chullet,

Thanks I will test with stored proc stage and then post the result.

[prasson_ibm]

Hi Chullet,
You are right its working in SP stage but i will also try to execute it in After SQL of the ODBC stage.
I am making this topic as resolved.