Re: SQL Agent Job

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Syntax? You want to add the job through stored procedure calls or using the GUI (SQL Server Management Studio, SSMS)? If you want to use SSMS, just use the Agent Node, Jobs, add a job, add a job step, make it CmdExec type and type the path and name of your exe file.

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi


"balajikkrishnan via SQLMonster.com" <u5178@uwe> wrote in message news:95b99adaa6810@xxxxxx
Can you guys send me the syntax to use it

Uri Dimant wrote:
Hi
I think it is possible , I have done such things with VB6 not with VB.NET
but it worth to try , is not it?

Hi All,

[quoted text clipped - 3 lines]
Thanks
Balaji

--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-programming/200905/1


.

Relevant Pages

  • Re: No Security
    ... remote instances in SSMS? ... What is SSMS? ... SQL Server Management Studio, you know, that program you admin SQL Server ...
    (microsoft.public.sqlserver.security)
  • Missing SSMS
    ... These are the instructions to get into SSMS ... "To open SQL Server Management Studio ... On the Start menu, point to All Programs, point to Microsoft SQL Server 2005, and then click SQL Server Management Studio." ...
    (microsoft.public.sqlserver.setup)
  • Re: Why I cant change collation w/ Query Analyzer, but can do that w/
    ... When making table changes you can generate a script in EM and SSMS ... SQL Server Management Studio, and what is in Mgmt Studio is very ...
    (microsoft.public.sqlserver.tools)
  • Re: SSIS - can SSIS pkg recognize a drive letter within SMS job?
    ... Realized from your process description that you were running SSMS from your ... I normally run SSMS on our Sql Server using a remote (terminal ... Uploaded the SSIS package which was simple and just contained one ... What is your SQL Server Agent service account? ...
    (microsoft.public.sqlserver.dts)
  • RE: SQL 2005 Management Studio cant edit text rows with > 4000 ch
    ... in SSMS, I cannot do the same thing. ... a text field, if I edit the int field, it fails. ... In SQL Server no matter 2000 or 2005, the default maximum size that can be ... table name','text in row',7000", the text-type field can support maximum ...
    (microsoft.public.sqlserver.tools)