Advertisement

02.07.2008 at 10:42AM PST, ID: 23145398
[x]
Attachment Details

a code to create a  job, to execute 2 diffeent stored procs, the first one has to check if a .xls file is available in a share

Asked by Alicia_Rose in MS SQL Server

Tags: sql, ie7

Hi experts,

I need to write a sql code to create a job and a stored procedure in it
The  job should execute  a stored pocedure(#1), which would check if a .xls file with name that starts with  'xyz' exists in a share.
If the file exists, then the job should excute a second stored proc, if not the job should exit without executing the second stored proc.  And send an email to a corporate alias.
I know to create a job from SQL Sever management Studio UI, i am not aware of how to code for it.
Any sort of help atleast for creating the stored procedure would be highly appreciated.

Thanks,
Alicia



Start Free Trial
 
Keywords: a code to create a job, to execute 2 …
Title
1 Convert csv to xls
2 .xls is locked for editing
3 Microsoft, XL, 2003
4 PCL XL Error
5 Import xls files automatically on Acces…
6 XLS file will not open in OO on a works…
 
Loading Advertisement...
 
[+][-]02.07.2008 at 10:46AM PST, ID: 20843655

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]02.07.2008 at 03:08PM PST, ID: 20846339

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]02.08.2008 at 06:10AM PST, ID: 20850160

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]02.08.2008 at 06:25AM PST, ID: 20850294

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]02.08.2008 at 10:56AM PST, ID: 20852885

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]02.08.2008 at 11:27AM PST, ID: 20853171

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]02.12.2008 at 09:04AM PST, ID: 20876630

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]02.12.2008 at 09:36AM PST, ID: 20876912

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]02.12.2008 at 10:48AM PST, ID: 20877499

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]02.12.2008 at 10:49AM PST, ID: 20877508

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]02.12.2008 at 11:04AM PST, ID: 20877639

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]02.15.2008 at 03:00PM PST, ID: 20906839

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]02.17.2008 at 02:08AM PST, ID: 20913539

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zone: MS SQL Server
Tags: sql, ie7
Sign Up Now!
Solution Provided By: dbaSQL
Participating Experts: 2
Solution Grade: A
 
 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628